[DERBY-1306] Support more than just varchar with vertical bars on query

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.1.2.1
• Component/s: SQL
• Labels: derby_triage10_11
• Environment: Relevant for this? Windows XP
• Urgency: Low
• Assignee: Unassigned
• Reporter: Bill Robertson
• Created: 10/May/06 01:29
• Updated: 25/Jun/13 14:50

Description

I'm not sure if this is ij or derby proper, but the concat operator || should work for just about any data type. Derby is zero maintenance, but data rarely is, and a good sql interface is important. Often it's very convenient to write a query that generates other sql statements and that's difficult w/o concatination.

e.g. create a table with a timestamp column, assume that the column name is originated.

Try the following query:

ij> select month(originated) || '-' || year(originated) from review;

get the following error:

ERROR 42846: Cannot convert types 'INTEGER' to 'VARCHAR'.

The conversion to a string should pretty much work all the time unless the operand is some sort of blob type.