[ http://issues.apache.org/jira/browse/DERBY-156?page=comments#action_60025 ] Bernd Ruehlicke commented on DERBY-156: ---------------------------------------
Yes, I agree - must be seen as a new feature. I got into the trouble when having a (generated) statement like DELETE FROM myTable x WHERE NOT EXISTS (SELECT * FROM mySecondTable y WHERE y.Col1 = x.Coln) I may get around this by decomposing this statement. > 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
