db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhilash T.G (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2012) The Syntax of the UPDATE and DELETE statements is not correct in the reference manual
Date Wed, 13 Feb 2008 17:33:09 GMT

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

Abhilash T.G updated DERBY-2012:
--------------------------------

    Derby Info: [Patch Available]

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


Mime
View raw message