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