You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <ji...@apache.org> on 2014/02/10 19:42:21 UTC

[jira] [Created] (DERBY-6476) Allow derived column lists in MERGE statements.

Rick Hillegas created DERBY-6476:
------------------------------------

             Summary: Allow derived column lists in MERGE statements.
                 Key: DERBY-6476
                 URL: https://issues.apache.org/jira/browse/DERBY-6476
             Project: Derby
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 10.11.0.0
            Reporter: Rick Hillegas
            Priority: Minor


Derby does not allow derived column lists aliased to the source or target tables in MERGE statement. So, the following statements are not allowed:

{noformat}
merge into t1_036 r( x )
using t2_036 on r.x = t2_036.a
when matched then delete;

merge into t1_036
using t2_036 r( x ) on t1_036.a = r.x
when matched then delete;
{noformat}

Problems with these derived column lists were noted by Knut in a 2014-02-07 comment on DERBY-3155.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)