[ http://issues.apache.org/jira/browse/DERBY-156?page=all ]
Andrew McIntyre updated DERBY-156: ---------------------------------- Fix Version: 10.2.0.0 (was: 10.1.0.0) Description: 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-) was: 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-) Version: 10.2.0.0 Environment: > Delete with alias on column fails > --------------------------------- > > Key: DERBY-156 > URL: http://issues.apache.org/jira/browse/DERBY-156 > Project: Derby > Type: New Feature > Components: SQL > Versions: 10.0.2.0, 10.0.2.1, 10.0.2.2, 10.2.0.0, 10.1.0.0 > Reporter: Bernd Ruehlicke > Priority: Critical > Fix For: 10.2.0.0 > > 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 - For more information on JIRA, see: http://www.atlassian.com/software/jira