Re: bug 5716 ..about Compatibility with DB2?

Thanks.

I have seen "A Guide to THE SQL STANDARD FOURTH EDITION" and
could not find any article about this.

This seems to be specific to DB2..

/*

        Tomohito Nakayama
        tomoihto-3vbGXx/L6hogx5LJoh7VlA@xxxxxxxxxxxxxxxx
        tomonaka-w3tBFbkRwq9dvEbG9P4ZtA@xxxxxxxxxxxxxxxx

        Naka
        http://www5.ocn.ne.jp/~tomohito/TopPage.html

*/
----- Original Message ----- 
From: "Satheesh Bandaram" <satheesh-FH/oHRRPlqlVF0LlKHyXCA@xxxxxxxxxxxxxxxx>
To: "Derby Development" <derby-dev-PvNy6fhA98DNLxjTenLetw@xxxxxxxxxxxxxxxx>
Sent: Wednesday, February 23, 2005 2:43 AM
Subject: Re: bug 5716 ..about Compatibility with DB2?


> Some of these checks where added to make Cloudscape (from where Derby
> evolved from) more standards and DB2 compatible much before it was
> contributed to Apache. I would check if SQL standard doesn't have this
> requirement before removing it in the code.
>
> Satheesh
>
> TomohitoNakayama wrote:
>
> > Hello.
> >
> > I'm trying to enable using expression in order clause.
> > In the task , I found next code with some comment.
> >
> > //bug 5716 - for db2 compatibility - no qualified names allowed in
> > order by clause when union/union all operator is used
> >
> > if (target instanceof SetOperatorNode && correlationName != null)
> > {
> > String fullName = (schemaName != null) ?
> > (schemaName + "." + correlationName + "." + columnName) :
> > (correlationName + "." + columnName);
> > throw
> > StandardException.newException(SQLState.LANG_QUALIFIED_COLUMN_NAME_NOT_ALLOWED,
> > fullName);
> > }
> >
> > Does anyone know anything about this ?
> > If possible, I want to ommit this code.....
> >
> > Best regards.
> >
> > /*
> >
> > Tomohito Nakayama
> > tomoihto-3vbGXx/L6hogx5LJoh7VlA@xxxxxxxxxxxxxxxx
> > tomonaka-w3tBFbkRwq9dvEbG9P4ZtA@xxxxxxxxxxxxxxxx
> >
> > Naka
> > http://www5.ocn.ne.jp/~tomohito/TopPage.html
> >
> > */
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 266.4.0 - Release Date: 2005/02/22



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.4.0 - Release Date: 2005/02/22