You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <ji...@apache.org> on 2007/07/19 17:56:06 UTC
[jira] Created: (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
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.
[jira] Updated: (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
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-2957:
----------------------------------
Fix Version/s: 10.4.0.0
10.3.1.5
> 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
> Fix For: 10.3.1.5, 10.4.0.0
>
>
> 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.
[jira] Resolved: (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
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden resolved DERBY-2957.
-----------------------------------
Resolution: Fixed
I reran this test and it passes now. It appears to have been resolved by another issue.
> 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.
[jira] 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
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ 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.