ASSERT in MergeSort.checkColumnTypes() disallow legal type conversions
----------------------------------------------------------------------

                 Key: DERBY-3310
                 URL: https://issues.apache.org/jira/browse/DERBY-3310
             Project: Derby
          Issue Type: Bug
          Components: SQL
            Reporter: Dyre Tjeldvoll
            Priority: Minor


The following code 

CREATE TABLE U (SNAME VARCHAR(32000), TNAME VARCHAR(32000), C1 BIGINT);
-- This triggers an ASSERT (because 2 is INTEGER and not BIGINT)
INSERT INTO U(SNAME, TNAME, C1) SELECT DISTINCT SCHEMANAME, TABLENAME, 2
 FROM SYS.SYSTABLES T JOIN SYS.SYSSCHEMAS S ON T.SCHEMAID = S.SCHEMAID;

gives

ERROR XJ001: Java exception: 'ASSERT FAILED col1.getClass() (class 
org.apache.derby.iapi.types.SQLInteger) expected to be the same as 
col2.getClass() (class org.apache.derby.iapi.types.SQLLongint): 
org.apache.derby.shared.common.sanity.AssertFailure'.

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

Reply via email to