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: About improvement of DERBY-134
Date Sun, 13 Mar 2005 17:40:26 GMT
Soory.
Mistaken.

> Q1:
> What is  "generated names" ?
> <"> "SQLCol NUMBER" <"> seems to be called "generated names".

Q1:
What is  "generated names" ?
<"> "SQLCol" NUMBER <"> seems to be called "generated names".

Best regards.

/*

         Tomohito Nakayama
         tomoihto@rose.zero.ad.jp
         tomonaka@basil.ocn.ne.jp

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

*/
----- Original Message ----- 
From: "TomohitoNakayama" <tomonaka@basil.ocn.ne.jp>
To: "Derby Development" <derby-dev@db.apache.org>
Sent: Monday, March 14, 2005 2:36 AM
Subject: Re: About improvement of DERBY-134


> Hello.
>
> I tried to change handling single column name in order by clause , and 
> just finished coding.
> Now single column name is treated as additiveExpression in afterPatch.
>
> And I have found next difference in orderby.out between beforePatch and 
> afterPatch as follows.
> I 'm confusing whether I should judge this is bug or not.
>
> beforePatch
> ij> -- . order by doesn't see generated names
> values (1,0,1),(1,0,0),(0,0,1),(0,1,0);
> 1          |2          |3
> -----------------------------------
> 1          |0          |1
> 1          |0          |0
> 0          |0          |1
> 0          |1          |0
> ij> values (1,0,1),(1,0,0),(0,0,1),(0,1,0) order by "SQLCol1";
> ERROR 42X78: Column 'SQLCol1' is not in the result of the query 
> expression.
> ij> values (1,0,1),(1,0,0),(0,0,1),(0,1,0) order by "SQLCol2";
> ERROR 42X78: Column 'SQLCol2' is not in the result of the query 
> expression.
> ij> values (1,0,1),(1,0,0),(0,0,1),(0,1,0) order by 1,1,2,3;
> 1          |2          |3
> -----------------------------------
> 0          |0          |1
> 0          |1          |0
> 1          |0          |0
> 1          |0          |1
>
> afterPatch
> ij> -- . order by doesn't see generated names ....?
> values (1,0,1),(1,0,0),(0,0,1),(0,1,0);
> 1          |2          |3
> -----------------------------------
> 1          |0          |1
> 1          |0          |0
> 0          |0          |1
> 0          |1          |0
>>-- now next was accepted.
> ij> values (1,0,1),(1,0,0),(0,0,1),(0,1,0) order by "SQLCol1";
> 1          |2          |3
> -----------------------------------
> 0          |1          |0
> 0          |0          |1
> 1          |0          |0
> 1          |0          |1
>>-- now next was accepted too.
> ij> values (1,0,1),(1,0,0),(0,0,1),(0,1,0) order by "SQLCol2";
> 1          |2          |3
> -----------------------------------
> 0          |0          |1
> 1          |0          |0
> 1          |0          |1
> 0          |1          |0
> ij> values (1,0,1),(1,0,0),(0,0,1),(0,1,0) order by 1,1,2,3;
> 1          |2          |3
> -----------------------------------
> 0          |0          |1
> 0          |1          |0
> 1          |0          |0
> 1          |0          |1
>
> I have some question now.
>
> Q1:
> What is  "generated names" ?
> <"> "SQLCol NUMBER" <"> seems to be called "generated names".
>
> Q2:
> Why was it error to use "generated name" in order by caluse as seen in 
> beforePatch?
>
> Q3:
> Is it bug to accept "generated names" in order clause like as in 
> afterPatcch ?
>
> Please give me some adivise...
>
> 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 outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 2005/03/11
>
>
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 2005/03/11
> 



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 2005/03/11


Mime
View raw message