Yes, this definitely a good feature add.
thanks Shreyas
Jack Klebanoff (JIRA) wrote:
[ http://issues.apache.org/jira/browse/DERBY-156?page=comments#action_60015 ]
Jack Klebanoff commented on DERBY-156:
--------------------------------------
The Derby reference manual does not document the use of correlation names in DELETE statements, so this is a feature request not a bug.
The SQL 2003 spec does allow correlation names in delete statements, so this is a very reasonable request.
SQL allows an optional 'AS' in front of the correlation name:
<delete statement: searched> ::= DELETE FROM <target table> [ [ AS ] <correlation name> ] [ WHERE <search condition> ]
If we do add this to Derby we should allow the optional "AS".
Delete with alias on column fails ---------------------------------
Key: DERBY-156
URL: http://issues.apache.org/jira/browse/DERBY-156
Project: Derby
Type: Bug
Reporter: Bernd Ruehlicke
Priority: Critical
DELETE FROM MY_TABLE x WHERE x.MY_COLUMN='value';
fails with ERROR 42X01: Syntax error: Encountered "x" at line 1, column 24
This is the core of the problem. I found it form a more complicated statement but it cooks down to that this should work but dose not.
B-)
