As this is a new feature and also involves changes the way SQL commands
for delete are parsed ( we need to support both with and without AS
keyword ) can someone give some pointers for starting. I have previously
worked in solving some correlation name bugs for Derby , this would be a
good one to dive in more deep.
~ Shreyas
Shreyas Kaushik wrote:
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-)
