[ 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-) -- 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 - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
