You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Christian d'Heureuse (JIRA)" <ji...@apache.org> on 2006/10/28 02:35:18 UTC
[jira] Created: (DERBY-2012) The Syntax of the UPDATE and DELETE
statements is not correct in the reference manual
The Syntax of the UPDATE and DELETE statements is not correct in the reference manual
-------------------------------------------------------------------------------------
Key: DERBY-2012
URL: http://issues.apache.org/jira/browse/DERBY-2012
Project: Derby
Issue Type: Improvement
Components: Documentation
Reporter: Christian d'Heureuse
Priority: Minor
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.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-2012) The Syntax of the UPDATE and DELETE
statements is not correct in the reference manual
Posted by "Dyre Tjeldvoll (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (DERBY-2012) The Syntax of the UPDATE and DELETE
statements is not correct in the reference manual
Posted by "Abhilash T.G (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Assigned: (DERBY-2012) The Syntax of the UPDATE and DELETE
statements is not correct in the reference manual
Posted by "Abhilash T.G (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abhilash T.G reassigned DERBY-2012:
-----------------------------------
Assignee: Abhilash T.G
> 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
>
> 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.
[jira] Resolved: (DERBY-2012) The Syntax of the UPDATE and DELETE
statements is not correct in the reference manual
Posted by "Jazarine Jamal (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (DERBY-2012) The Syntax of the UPDATE and DELETE
statements is not correct in the reference manual
Posted by "Abhilash T.G (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abhilash T.G updated DERBY-2012:
--------------------------------
Attachment: DERBY-2012.diff
I made changes to the following:
rrefsqlj26498.dita
rrefsqlj35981.dita
The recommended changes have been made.
The diff file and a zip file have been attached.
> 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.