Derby
  1. Derby
  2. DERBY-2896

DatabaseMetaData.getTables() fails in TERRORITY_BASED collation database with SQLState 42818: Comparisions between CHAR and CHAR not allowed.

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: 10.3.1.4, 10.4.1.3
    • Fix Version/s: 10.3.1.4, 10.4.1.3
    • Component/s: JDBC
    • Labels:
      None

      Description

      I tried adding DatabaseMetaDataTest.suite() to be run within CollationTest so that it would test DatabaseMetaData within a collated database.
      I had to fix one item in JDBC.dropSchema() where a string constant was being compared to a system column while not in a system schema,
      but with that fixed the next error hit was executing DatabaseMetaData.getTables().

      I will add the code to collation test with the use of DatabaseMetaDataTest commented out with this bug number.

      1. Test2896.zip
        176 kB
        Stan Bradbury

        Issue Links

          Activity

          Daniel John Debrunner created issue -
          Daniel John Debrunner made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-2894 [ DERBY-2894 ]
          Stan Bradbury made changes -
          Attachment Test2896.zip [ 12361551 ]
          Stan Bradbury made changes -
          Attachment Test2896.zip [ 12361551 ]
          Stan Bradbury made changes -
          Attachment Test2896.zip [ 12361552 ]
          Myrna van Lunteren made changes -
          Summary DatabaseMetaData.getTables() fails in TERRORITY_BASED collation database with 42818 Comparisions between CHAR and CHAR not allowed. DatabaseMetaData.getTables() fails in TERRORITY_BASED collation database with SQLState 42818: Comparisions between CHAR and CHAR not allowed.
          Myrna van Lunteren made changes -
          Assignee Mamta A. Satoor [ mamtas ]
          Myrna van Lunteren made changes -
          Priority Critical [ 2 ] Blocker [ 1 ]
          Myrna van Lunteren made changes -
          Resolution Fixed [ 1 ]
          Fix Version/s 10.4.0.0 [ 12312540 ]
          Fix Version/s 10.3.1.3 [ 12312567 ]
          Status Open [ 1 ] Resolved [ 5 ]
          Dyre Tjeldvoll made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12407583 ] Default workflow, editable Closed status [ 12797952 ]

            People

            • Assignee:
              Mamta A. Satoor
              Reporter:
              Daniel John Debrunner
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development