[DERBY-4388] NullPointerException in RIGHT JOIN with NOT BETWEEN

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.0.2.1, 10.1.3.1, 10.2.2.0, 10.3.3.0, 10.4.2.0, 10.5.3.0, 10.6.1.0
• Fix Version/s: 10.5.3.1, 10.6.1.0
• Component/s: SQL
• Issue & fix info: Repro attached
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 25/Sep/09 13:07
• Updated: 15/Oct/09 09:47
• Resolved: 15/Oct/09 09:47

Description

ij> create table t1(x int);
0 rows inserted/updated/deleted
ij> create table t2(x int);
0 rows inserted/updated/deleted
ij> insert into t2 values (1);
1 row inserted/updated/deleted
ij> select * from t1 right join t2 on t1.x = t2.x where t1.x not between 0 and 4;
X |X
-----------------------
ERROR 38000: The exception 'java.lang.NullPointerException' was thrown while evaluating an expression.
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.

Issue Links

• relates to: DERBY-4342 SQLSTATE 38000 (NullPointerException) at inner self join and value(x1, x2...)