[DERBY-6421] Cast to UDT in CHECK constraint causes NPE or assert failure

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.10.1.1
• Fix Version/s: 10.11.1.1
• Component/s: SQL
• Issue & fix info: Repro attached
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 25/Nov/13 17:12
• Updated: 21/Jan/15 00:23
• Resolved: 05/Dec/13 12:09

Description

ij version 10.10
ij> connect 'jdbc:derby:memory:db;create=true';
ij> create type typ external name 'java.util.ArrayList' language java;
0 rows inserted/updated/deleted
ij> create table ttt(x int, check (cast(null as typ) is null));
0 rows inserted/updated/deleted
ij> insert into ttt values 1,2,3;
ERROR XJ001: Java exception: ': java.lang.NullPointerException'.

or with debug build:

ij> insert into ttt values 1,2,3;
ERROR XJ001: Java exception: 'ASSERT FAILED no current dependent for compilation: org.apache.derby.shared.common.sanity.AssertFailure'.