db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Danesh Irani <danes...@gmail.com>
Subject Re: [jira] Commented: (DERBY-156) Delete with alias on column fails
Date Sun, 03 Apr 2005 15:57:18 GMT
If I'm not mistaken the place to start for modifying the way SQL is
parsed is to look at sqlgrammar.jj under
org.apache.derby.impl.sql.compile. I'm just starting with Derby dev
myself so dont take my word for it.

~Danesh

On Apr 3, 2005 10:21 AM, Shreyas Kaushik <Shreyas.Kaushik@sun.com> wrote:
> 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