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

AssertFailure when selecting rows from a table with CHARACTER and VARCHAR columns

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0
    • 10.4.2.1, 10.5.1.1, 10.6.1.0
    • SQL
    • None
    • High Value Fix
    • Crash, Regression

    Description

      When running a complex query on this table:

      [code]
      Create table DEMO.TEST (
      CHR CHARACTER(26) ,
      VCHR VARCHAR(25) )
      [code]

      then I get this exception:

      AssertFailure: ASSERT FAILED col1.getClass() (class ...SQLChar) expected to be the same as col2.getClass() (class ....SQLVarchar)' was thrown while evaluating an expression.

      Attachments

        1. derby-4071-10_4.stat
          0.2 kB
          Dag H. Wanvik
        2. derby-4071-10_4.diff
          5 kB
          Dag H. Wanvik
        3. derby-4071.stat
          0.2 kB
          Dag H. Wanvik
        4. derby-4071.diff
          5 kB
          Dag H. Wanvik
        5. trialPatch.diff
          2 kB
          Dag H. Wanvik
        6. DerbyTest.java
          9 kB
          Aaron Digulla

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4247 Null pointer exception generated when preparing a statement containing "IN (?)" or "= ?", but not if using "IN (?, ?)" or enclosing the select query in another query.

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4247 Null pointer exception generated when preparing a statement containing "IN (?)" or "= ?", but not if using "IN (?, ?)" or enclosing the select query in another query.

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

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-681 Eliminate the parser's rewriting of the abstract syntax tree for queries with GROUP BY and/or HAVING clauses

          • Major - Major loss of function.
          • Closed

          Activity

            People

              dagw Dag H. Wanvik
              digulla Aaron Digulla
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: