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

ASSERT in MergeSort.checkColumnTypes() disallow legal type conversions

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.4.1.3
    • 10.4.1.3, 10.5.1.1
    • SQL
    • None
    • Patch Available
    • 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. cast-repro.sql
          0.6 kB
          Dyre Tjeldvoll
        2. d3310_writeup_1.html
          99 kB
          A B
        3. derby-3310_diff.txt
          4 kB
          Katherine Marsden
        4. derby-3310_diff.txt
          5 kB
          Katherine Marsden
        5. derby-3310_remove_genNormalizeResultSetNode_diff.txt
          8 kB
          Katherine Marsden
        6. derby3310_rsn_cleanup_1.txt
          6 kB
          Daniel John Debrunner
        7. derby-3310_try1_diff.txt
          4 kB
          Katherine Marsden

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-3221 "java.sql.SQLException: The conglomerate (-5) requested does not exist." from Derby 10.3.1.4 embedded within Eclipse 3.3 and RAD 7.0

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-3395 'An ON clause associated with a JOIN operator is not valid.' failure with 10.3.2.1 passes with 10.2

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-2775 DataTypeDescriptor should be immutable so that multiple ValueNode referring to the same DTD do not have unexpected state changes.

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-3494 Move the setup of NormalizeResultSetNode into the NormalizeResultSetNode

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              kmarsden Katherine Marsden
              dyret Dyre Tjeldvoll
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: