[DERBY-6026] NullPointerException when calling string function in predicate with territory based collation

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2, 10.8.2.2, 10.8.3.0, 10.9.1.0, 10.10.1.1
• Component/s: SQL
• Labels: derby_triage10_11
• Urgency: Urgent
• Bug behavior facts: Regression
• Assignee: Unassigned
• Reporter: Knut Anders Hatlen
• Created: 21/Dec/12 11:20
• Updated: 19/Jun/13 08:37

Description

ij version 10.9
ij> connect 'jdbc:derby:memory:colldb;create=true;territory=en_US;collation=TERRITORY_BASED';
ij> create table t(x varchar(10));
0 rows inserted/updated/deleted
ij> insert into t values 'abc';
1 row inserted/updated/deleted
ij> select * from t where x = trim('xyz');
X
----------
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.

Issue Links

• is duplicated by: DERBY-6031 NullPointerException when comparing string with result from string function in territory based collation