db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "TomohitoNakayama" <tomon...@basil.ocn.ne.jp>
Subject Re: bug 5716 ..about Compatibility with DB2?
Date Thu, 24 Feb 2005 10:39:48 GMT
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@rose.zero.ad.jp
         tomonaka@basil.ocn.ne.jp

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

*/
----- Original Message ----- 
From: "Satheesh Bandaram" <satheesh@Sourcery.Org>
To: "Derby Development" <derby-dev@db.apache.org>
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@rose.zero.ad.jp
>> tomonaka@basil.ocn.ne.jp
>>
>> 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


Mime
View raw message