[
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.
