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] Issue Comment Edited: (DERBY-4433) Cannot insert from EXCEPT/INTERSECT when target table has more columns than the source
Date Thu, 19 Nov 2009 09:55:41 GMT

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

Knut Anders Hatlen edited comment on DERBY-4433 at 11/19/09 9:54 AM:
---------------------------------------------------------------------

I agree that this issue could be seen as part of DERBY-4442, so it might make sense to shift
the effort to that bug. I'm cautiously optimistic, though, that the suggested approach in
this issue could serve as a first step towards DERBY-4442.

If you want to get going on DERBY-4442, then I'd say just go ahead. I haven't looked much
at this issue after the initial evaluation, and could put it on hold and revisit it after
DERBY-4442 (when there hopefully will be nothing more to do except writing a test case). If
you can use some of the code I've posted here, feel free to recycle it over at that issue.

      was (Author: knutanders):
    I agree that this issue could be seen as part of DERBY-4442, so it might make sense to
shift the effort to that bug. I'm cautiously optimistic, though, that the suggested approach
in this issue could serve as a first step towards DERBY-4442.

If you want to get going on DERBY-4442, then I'd say just go ahead. I haven't looked much
at this issue after the initial evaluation, and put it on hold and revisit it after DERBY-4442
(when there hopefully will be nothing more to do except writing a test case). If you can use
some of the code I've posted here, feel free to recycle it over at that issue.
  
> 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