db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dyre Tjeldvoll (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 19:15:08 GMT

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

Dyre Tjeldvoll updated DERBY-2012:
----------------------------------

    Derby Info:   (was: [Patch Available])

Thanks!

Committed revision 627566.

> 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