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

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

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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.

        Attachments

        1. Test2896.zip
          176 kB
          Sun Seng David Tan

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: