Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <138733348.1257248703509.JavaMail.jira@brutus>
Date: Tue, 3 Nov 2009 11:45:03 +0000 (UTC)
From: "Knut Anders Hatlen (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Created: (DERBY-4433) Cannot insert from EXCEPT/INTERSECT
 when target table has more columns than the source
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

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


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.