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

["Knut Anders Hatlen (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DERBY-6421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13836137#comment-13836137 ] 

Knut Anders Hatlen commented on DERBY-6421:
-------------------------------------------

Also affects generated columns:

{noformat}
ij> create table t1(x typ generated always as (cast(null as typ)));
0 rows inserted/updated/deleted
ij> insert into t1 values default;
ERROR XJ001: Java exception: 'ASSERT FAILED no current dependent for compilation: org.apache.derby.shared.common.sanity.AssertFailure'.
{noformat}

> Cast to UDT in CHECK constraint causes NPE or assert failure
> ------------------------------------------------------------
>
>                 Key: DERBY-6421
>                 URL: https://issues.apache.org/jira/browse/DERBY-6421
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.10.1.1
>            Reporter: Knut Anders Hatlen
>
> 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'.



--
This message was sent by Atlassian JIRA
(v6.1#6144)