db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [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
Date Wed, 14 Nov 2007 22:36:43 GMT

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


Mime
View raw message