Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3310

ASSERT in MergeSort.checkColumnTypes() disallow legal type conversions

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.4.1.3
    • Fix Version/s: 10.4.1.3, 10.5.1.1
    • Component/s: SQL
    • Labels:
      None
    • Issue & fix info:
      Patch Available
    • Bug behavior facts:
      Regression

      Description

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

        Attachments

        1. derby-3310_try1_diff.txt
          4 kB
          Kathey Marsden
        2. derby3310_rsn_cleanup_1.txt
          6 kB
          Daniel John Debrunner
        3. derby-3310_remove_genNormalizeResultSetNode_diff.txt
          8 kB
          Kathey Marsden
        4. derby-3310_diff.txt
          5 kB
          Kathey Marsden
        5. derby-3310_diff.txt
          4 kB
          Kathey Marsden
        6. d3310_writeup_1.html
          99 kB
          A B
        7. cast-repro.sql
          0.6 kB
          Dyre Tjeldvoll

          Issue Links

            Activity

              People

              • Assignee:
                kmarsden Kathey Marsden
                Reporter:
                dyret Dyre Tjeldvoll
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: