Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1989435719.1204550210583.JavaMail.jira@brutus>
Date: Mon, 3 Mar 2008 05:16:50 -0800 (PST)
From: "Jazarine Jamal (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Resolved: (DERBY-2012) The Syntax of the UPDATE and DELETE
 statements is not correct in the reference manual
In-Reply-To: <26693046.1161995718987.JavaMail.root@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DERBY-2012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jazarine Jamal resolved DERBY-2012.
-----------------------------------

    Resolution: Fixed

> The Syntax of the UPDATE and DELETE statements is not correct in the reference manual
> -------------------------------------------------------------------------------------
>
>                 Key: DERBY-2012
>                 URL: https://issues.apache.org/jira/browse/DERBY-2012
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>            Reporter: Christian d'Heureuse
>            Assignee: Abhilash T.G
>            Priority: Minor
>         Attachments: DERBY-2012.diff
>
>
> The syntax description of the UPDATE and DELETE statements in the reference manual does not imply that an alias name may be specified for the table name.
> The statements are currently documented as:
>   UPDATE table-Name
>     SET ...
>   DELETE FROM table-Name
>     [ WHERE ... ]
> This should be changed to:
>   UPDATE table-Name  [ [ AS ] correlation-Name ]
>     SET ...
>   DELETE FROM table-Name [ [ AS ] correlation-Name ]
>     [ WHERE ... ]
> (Table alias names for UPDATE and DELETE are important for the WHERE clauses, e.g. when the same table is used a second time within a subquery in the WHERE condition, e.g.:
>   UPDATE table1 a
>     SET ...
>       WHERE EXISTS (
>         SELECT * FROM table1 b WHERE a.field1 = b.field2 )

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.