[DERBY-4391] NullPointerException when comparing indexed column with result from a set operation

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 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: 30/Sep/09 11:25
• Updated: 15/Oct/09 21:01
• Resolved: 14/Oct/09 22:24

Description

I'm reporting this issue on behalf of Bernt M. Johnsen.

If an indexed column is compared with a UNION query (or some other set operation), a NullPointerException is raised, as can be seen by this sequence of statements in ij:

ij> create table t(a int not null primary key, b int);
0 rows inserted/updated/deleted
ij> select * from t where a < (values 4 union values 4);
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.

Issue Links

• is related to: DERBY-4411 Scalar subquery erroneously rejected for not returning exactly one row