db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "C.S. Nirmal J. Fernando (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4371) Non-selected columns for SELECT DISTINCT allowed in ORDER BY clause if ordered by expression
Date Sun, 25 Apr 2010 06:03:50 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4371?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12860658#action_12860658
] 

C.S. Nirmal J. Fernando commented on DERBY-4371:
------------------------------------------------

Hi All,

I ran the derbyall tests with my modification, but it failed (I was wondering why). Following
is a quote from derbyall_report.txt:

Generating report for RunSuite derbyall  null null null true 
------------------ Java Information ------------------
Java Version:    1.6.0_16
Java Vendor:     Sun Microsystems Inc.
Java home:       C:\Program Files\Java\jre6
Java classpath:  %classpath%;C:\OtherNirmal\GSoC\Code\jars\sane\derby.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbytools.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyrun.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbynet.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyclient.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyTesting.jar;C:\OtherNirmal\GSoC\Code\tools\java\jakarta-oro-2.0.8.jar;C:\OtherNirmal\GSoC\Code\tools\java\junit.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_cs.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_de_DE.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_es.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_fr.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_hu.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_it.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_ja_JP.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_ko_KR.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_pl.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_pt_BR.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_ru.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_zh_CN.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_zh_TW.jar;C:\OtherNirmal\GSoC\xalan-j_2_7_1-bin-2jars\xalan-j_2_7_1\samples\xalansamples.jar;C:\OtherNirmal\GSoC\Document\lib\fop.jar;C:\OtherNirmal\GSoC\Document\lib\avalon-framework-4.2.0.jar;C:\OtherNirmal\GSoC\Document\lib\batik-all-1.6.jar;.
OS name:         Windows Vista
OS architecture: x86
OS version:      6.0
Java user name:  Nirmal
Java user home:  C:\Users\Nirmal
Java user dir:   C:\OtherNirmal\GSoC\Testing\DerbyAll
java.specification.name: Java Platform API Specification
java.specification.version: 1.6
--------- Derby Information --------
JRE - JDBC: Java SE 6 - JDBC 4.0
[C:\OtherNirmal\GSoC\Code\jars\sane\derby.jar] 10.6.0.0 alpha - (exported)
[C:\OtherNirmal\GSoC\Code\jars\sane\derbytools.jar] 10.6.0.0 alpha - (exported)
[C:\OtherNirmal\GSoC\Code\jars\sane\derbynet.jar] 10.6.0.0 alpha - (exported)
[C:\OtherNirmal\GSoC\Code\jars\sane\derbyclient.jar] 10.6.0.0 alpha - (exported)
------------------------------------------------------
----------------- Locale Information -----------------
Current Locale :  [English/United States [en_US]]
Found support for locale: [cs]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [de_DE]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [es]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [fr]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [hu]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [it]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [ja_JP]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [ko_KR]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [pl]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [pt_BR]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [ru]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [zh_CN]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [zh_TW]
	 version: 10.6.0.0 alpha - (exported)
------------------------------------------------------
Test environment information:
COMMAND LINE STYLE: jdk13
TEST CANONS: master
------------------------------------------------------
------------------------------------------------------
Summary results:

Test Run Started: 2010-04-25 01:19:16.0
Test Run Duration: 00:48:47

204 Tests Run
31% Pass (65 tests passed)
69% Fail (139 tests failed)
3 Suites skipped

=================================================================
Since I was pretty sure, that these failures occurred not because of my modifications, I ran
derbyall again after commenting the code I added.
The result was what I expected.

Generating report for RunSuite derbyall  null null null true 
------------------ Java Information ------------------
Java Version:    1.6.0_16
Java Vendor:     Sun Microsystems Inc.
Java home:       C:\Program Files\Java\jre6
Java classpath:  %classpath%;C:\OtherNirmal\GSoC\Code\jars\sane\derby.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbytools.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyrun.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbynet.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyclient.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyTesting.jar;C:\OtherNirmal\GSoC\Code\tools\java\jakarta-oro-2.0.8.jar;C:\OtherNirmal\GSoC\Code\tools\java\junit.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_cs.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_de_DE.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_es.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_fr.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_hu.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_it.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_ja_JP.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_ko_KR.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_pl.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_pt_BR.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_ru.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_zh_CN.jar;C:\OtherNirmal\GSoC\Code\jars\sane\derbyLocale_zh_TW.jar;C:\OtherNirmal\GSoC\xalan-j_2_7_1-bin-2jars\xalan-j_2_7_1\samples\xalansamples.jar;C:\OtherNirmal\GSoC\Document\lib\fop.jar;C:\OtherNirmal\GSoC\Document\lib\avalon-framework-4.2.0.jar;C:\OtherNirmal\GSoC\Document\lib\batik-all-1.6.jar;.
OS name:         Windows Vista
OS architecture: x86
OS version:      6.0
Java user name:  Nirmal
Java user home:  C:\Users\Nirmal
Java user dir:   C:\OtherNirmal\GSoC\Testing\DerbyAll2
java.specification.name: Java Platform API Specification
java.specification.version: 1.6
--------- Derby Information --------
JRE - JDBC: Java SE 6 - JDBC 4.0
[C:\OtherNirmal\GSoC\Code\jars\sane\derby.jar] 10.6.0.0 alpha - (exported)
[C:\OtherNirmal\GSoC\Code\jars\sane\derbytools.jar] 10.6.0.0 alpha - (exported)
[C:\OtherNirmal\GSoC\Code\jars\sane\derbynet.jar] 10.6.0.0 alpha - (exported)
[C:\OtherNirmal\GSoC\Code\jars\sane\derbyclient.jar] 10.6.0.0 alpha - (exported)
------------------------------------------------------
----------------- Locale Information -----------------
Current Locale :  [English/United States [en_US]]
Found support for locale: [cs]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [de_DE]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [es]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [fr]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [hu]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [it]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [ja_JP]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [ko_KR]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [pl]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [pt_BR]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [ru]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [zh_CN]
	 version: 10.6.0.0 alpha - (exported)
Found support for locale: [zh_TW]
	 version: 10.6.0.0 alpha - (exported)
------------------------------------------------------
Test environment information:
COMMAND LINE STYLE: jdk13
TEST CANONS: master
------------------------------------------------------
------------------------------------------------------
Summary results:

Test Run Started: 2010-04-25 10:29:54.0
Test Run Duration: 00:48:08

204 Tests Run
31% Pass (65 tests passed)
69% Fail (139 tests failed)
3 Suites skipped

============================================================

But, since the both reports failed same number of tests, I suppose I can conclude that my
modifications, not resulted of failure of any tests.

Expect your views on this.

Thanks.

> Non-selected columns for SELECT DISTINCT allowed in ORDER BY clause if ordered by expression
> --------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4371
>                 URL: https://issues.apache.org/jira/browse/DERBY-4371
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.1.1
>            Reporter: Bernt M. Johnsen
>            Assignee: C.S. Nirmal J. Fernando
>            Priority: Critical
>         Attachments: DERBY-4371.diff
>
>
> How to repeat:
> ij> create table t (i integer, j integer);;
> 0 rows inserted/updated/deleted
> ij> insert into t values (1,2),(1,3);
> 2 rows inserted/updated/deleted
> ij> select distinct i from t order by j;
> ERROR 42879: The ORDER BY clause may not contain column 'J', since the query specifies
DISTINCT and that column does not appear in the query result.
> ij> select distinct i from t order by j*2;
> I          
> -----------
> 1          
> 1          
> 2 rows selected

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message