[
https://issues.apache.org/jira/browse/DERBY-2957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kathey Marsden closed DERBY-2957.
---------------------------------
> ASSERT FAILED col1.getClass() (class org.apache.derby.iapi.types.SQLChar)
> expected to be the same as col2.getClass() (class
> org.apache.derby.iapi.types.CollatorSQLChar) in NistScripts dml002 test with
> collated database
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2957
> URL: https://issues.apache.org/jira/browse/DERBY-2957
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.4.0.0
> Reporter: Kathey Marsden
>
> With a collated database dml001 fails on statement
> -- TEST:0004 SELECT with UNION, ORDER BY integer DESC!
> SELECT WORKS.EMPNUM
> FROM WORKS
> WHERE WORKS.PNUM = 'P2'
> UNION
> SELECT STAFF.EMPNUM
> FROM STAFF
> WHERE STAFF.GRADE=13
> ORDER BY 1 DESC;
> EM&
> ---
> E5
> E4
> E3
> E2
> E1
> ij> -- PASS:0004 If 5 rows selected and last EMPNUM = 'E1'?
> -- END TEST >>> 0004 <<< END TEST
> -- *********************************************
> -- TEST:0005 SELECT with UNION ALL!
> SELECT WORKS.EMPNUM
> FROM WORKS
> WHERE WORKS.PNUM = 'P2'
> UNION ALL
> SELECT STAFF.EMPNUM
> FROM STAFF
> WHERE STAFF.GRADE = 13;
> EM&
> ---
> E1
> E2
> E3
> E4
> E3
> E5
> ij> -- PASS:0005 If 6 rows selected?
> -- END TEST >>> 0005 <<< END TEST
> -- *********************************************
> -- TEST:0158 SELECT with UNION and NOT EXISTS subquery!
> SELECT EMPNAME,PNUM,HOURS
> FROM STAFF,WORKS
> WHERE STAFF.EMPNUM = WORKS.EMPNUM
> UNION
> SELECT EMPNAME,PNUM,HOURS
> FROM STAFF,WORKS
> WHERE NOT EXISTS
> (SELECT HOURS
> FROM WORKS
> WHERE STAFF.EMPNUM = WORKS.EMPNUM);
> EMPNAME |PN&|HOURS
> -------------------------------
> Alice |P1 |40
> Alice |P2 |20
> Alice |P3 |80
> Alice |P4 |20
> Alice |P5 |12
> Alice |P6 |12
> Betty |P1 |40
> Betty |P2 |80
> Carmen |P2 |20
> Don |P2 |20
> Don |P4 |40
> Don |P5 |80
> Ed |P1 |40
> Ed |P2 |20
> Ed |P2 |80
> Ed |P3 |80
> Ed |P4 |20
> Ed |P4 |40
> Ed |P5 |12
> Ed |P5 |80
> Ed |P6 |12
> ij> -- PASS:0158 If 21 rows selected?
> -- END TEST >>> 0158 <<< END TEST
> -- *********************************************
> -- TEST:0159 SELECT with 2 UNIONs, ORDER BY 2 integers!
> SELECT PNUM,EMPNUM,HOURS
> FROM WORKS
> WHERE HOURS=80
> UNION
> SELECT PNUM,EMPNUM,HOURS
> FROM WORKS
> WHERE HOURS=40
> UNION
> SELECT PNUM,EMPNUM,HOURS
> FROM WORKS
> WHERE HOURS=20
> ORDER BY 3,1;
> PN&|EM&|HOURS
> --------------
> P2 |E4 |20
> P2 |E3 |20
> P2 |E1 |20
> P4 |E1 |20
> P1 |E2 |40
> P1 |E1 |40
> P4 |E4 |40
> P2 |E2 |80
> P3 |E1 |80
> P5 |E4 |80
> ij> -- PASS:0159 If 10 rows selected?
> -- END TEST >>> 0159 <<< END TEST
> -- *********************************************
> -- TEST:0160 SELECT with parenthesized UNION, UNION ALL!
> SELECT PNUM,EMPNUM,HOURS
> FROM WORKS
> WHERE HOURS=12
> UNION ALL
> (SELECT PNUM,EMPNUM,HOURS
> FROM WORKS
> UNION
> SELECT PNUM,EMPNUM,HOURS
> FROM WORKS
> WHERE HOURS=80)
> ORDER BY 2,1;
> With error:
> junit.framework.ComparisonFailure: Output at line 82 expected:<...M&> but
> was:<...RROR XJ001: Java exception: 'ASSERT FAILED col1.getClass() (class
> org.apache.derby.iapi.types.SQLChar) expected to be the same as
> col2.getClass() (class org.apache.derby.iapi.types.CollatorSQLChar):
> org.apache.derby.shared.common.sanity.AssertFailure'.>
> at junit.framework.Assert.assertEquals(Assert.java:81)
> at
> org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
> at
> org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:124)
> at junit.framework.TestCase.runBare(TestCase.java:127)
> at
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
> at junit.framework.TestResult$1.protect(TestResult.java:106)
> at junit.framework.TestResult.runProtected(TestResult.java:124)
> at junit.framework.TestResult.run(TestResult.java:109)
> at junit.framework.TestCase.run(TestCase.java:118)
> at junit.framework.TestSuite.runTest(TestSuite.java:208)
> at junit.framework.TestSuite.run(TestSuite.java:203)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.framework.TestResult.runProtected(TestResult.java:124)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.framework.TestSuite.runTest(TestSuite.java:208)
> at junit.framework.TestSuite.run(TestSuite.java:203)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.framework.TestResult.runProtected(TestResult.java:124)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.framework.TestResult.runProtected(TestResult.java:124)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.framework.TestResult.runProtected(TestResult.java:124)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.framework.TestResult.runProtected(TestResult.java:124)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.framework.TestResult.runProtected(TestResult.java:124)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.framework.TestSuite.runTest(TestSuite.java:208)
> at junit.framework.TestSuite.run(TestSuite.java:203)
> at junit.framework.TestSuite.runTest(TestSuite.java:208)
> at junit.framework.TestSuite.run(TestSuite.java:203)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.framework.TestResult.runProtected(TestResult.java:124)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.framework.TestResult.runProtected(TestResult.java:124)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.framework.TestResult.runProtected(TestResult.java:124)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at TimeRunner.main(TimeRunner.java:29)
> 16 dml001(org.apache.derbyTesting.functionTests.tests.nist.NistScripts)
> I have not been able to get a standalone repro yet.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
