[DERBY-2956] With a collated database USER cannot be used in query against user tables without cast

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 10.4.1.3
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Katherine Marsden
• Created: 19/Jul/07 15:01
• Updated: 26/Jul/07 16:35
• Resolved: 19/Jul/07 17:13

Description

ij> create table staff (empname varchar(30));
0 rows inserted/updated/deleted
ij> insert into staff values('APP');
1 row inserted/updated/deleted
ij> insert into staff values('KATHEY');
1 row inserted/updated/deleted
ij> select * from staff where empname like USER;
ERROR 42ZA2: Operand of LIKE predicate with type VARCHAR(30) and collation TERRITORY_BASED is not compatable with LIKE p
attern operand with type VARCHAR(128) and collation UCS_BASIC.
ij>

Workaround is to use a cast

ij> select * from staff where empname like CAST(USER as VARCHAR(30));
EMPNAME
------------------------------
APP

1 row selected

Issue Links

• is related to: DERBY-2656 Run suites.All against a collated database