db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4433) Cannot insert from EXCEPT/INTERSECT when target table has more columns than the source
Date Wed, 04 Nov 2009 23:11:32 GMT

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

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

Thanks Dag! Unfortunately, there were two failures in suites.All.

1) GeneratedColumnsTest:
> create table t_insert_3( a int, b int generated always as ( -a ) );
> insert into t_insert_3 values ( 2, default ), ( 3, default ), ( 4, default )
---> SQLSyntaxErrorException: You may not override the value of generated column 'B'.

2) LangScripts, union.sql:
> create table insert_test (i int, s smallint, d double precision, r real,
>         c10 char(10), c30 char(30), vc10 varchar(10), vc30 varchar(30));
> insert into insert_test (s, i) values (2, 1) union values (4, 3);
---> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.

> Cannot insert from EXCEPT/INTERSECT when target table has more columns than the source
> --------------------------------------------------------------------------------------
>
>                 Key: DERBY-4433
>                 URL: https://issues.apache.org/jira/browse/DERBY-4433
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.6.0.0
>            Reporter: Knut Anders Hatlen
>            Assignee: Knut Anders Hatlen
>         Attachments: prn.diff
>
>
> If an INSERT statement takes the rows to insert from an EXCEPT query or an INTERSECT
query, the statement fails with "Column position 'X' out of range" if the target table contains
more columns than the result returned from EXCEPT or INTERSECT.
> Example:
> ij> create table t (x int, y int);
> 0 rows inserted/updated/deleted
> ij> insert into t(x) select x from t except select x from t;
> ERROR 42X77: Column position '2' is out of range for the query expression.
> ij> insert into t(x) select x from t intersect select x from t;
> ERROR 42X77: Column position '2' is out of range for the query expression.
> The corresponding UNION query works:
> ij> insert into t(x) select x from t union select x from t;
> 0 rows inserted/updated/deleted

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message