Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Mon, 31 Mar 2014 17:25:19 +0000 (UTC)
From: "Rick Hillegas (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <JIRA.12703264.1395684805162.37461.1396286719637@arcas>
In-Reply-To: <JIRA.12703264.1395684805162@arcas>
References: <JIRA.12703264.1395684805162@arcas>
Subject: [jira] [Commented] (DERBY-6526) Document the MERGE statement
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Rick Hillegas commented on DERBY-6526:
--------------------------------------

Thanks for the patch, Kim. A couple comments:

rrefkeywords29722:

o MERGE and MATCHED are non-reserved keywords, so they should not appear in this list.

o While I was in there, I discovered some other problems with this page:

  OVER and ROW_NUMBER are non-reserved too, so they shouldn't appear in this list

  CHARACTER_LENGTH and LEADING are reserved keywords which should appear in this list


rrefsqljmerge

o I see that the functional spec incorrectly describes the restrictions on identity and generated columns. I will update the spec to say this: INSERT column lists may not mention identity columns. In a VALUES clause, DEFAULT is the only value allowed for generated columns. On the right side of SET operators for UPDATE actions, DEFAULT is the only value allowed for generated and identity columns.

o I think it would be good to state somewhere that the row count for a successful MERGE statement is the total number of rows inserted, updated, and deleted by the statement.

Thanks
-Rick


> Document the MERGE statement
> ----------------------------
>
>                 Key: DERBY-6526
>                 URL: https://issues.apache.org/jira/browse/DERBY-6526
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.11.0.0
>            Reporter: Rick Hillegas
>            Assignee: Kim Haase
>         Attachments: DERBY-6526.diff, DERBY-6526.stat, DERBY-6526.zip
>
>
> The MERGE statement is ready to be documented. Hopefully, the functional spec attached to DERBY-3155 is complete enough for this task.


--
This message was sent by Atlassian JIRA
(v6.2#6252)