db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: bug 5716 ..about Compatibility with DB2?
Date Tue, 22 Feb 2005 17:43:50 GMT
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
>
> */
>
>


Mime
View raw message