[jira] Issue Comment Edited: (DERBY-4433) Cannot insert from EXCEPT/INTERSECT when target table has more columns than the source

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

    [ 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.