db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shreyas Kaushik <Shreyas.Kaus...@Sun.COM>
Subject Re: [jira] Commented: (DERBY-156) Delete with alias on column fails
Date Sun, 03 Apr 2005 14:21:43 GMT
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-)
>>>   
>>
>>
>>  
>>


Mime
View raw message