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

Change functional tests to use casts for System table queries to avoid conversion errors when run with TERRITORY_BASED collation

    Details

    • Type: Task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.4.1.3
    • Fix Version/s: 10.4.1.3
    • Component/s: Test
    • Labels:
      None

      Description

      Many of the tests use system table queries which fail when run against a database with TERRITORY_BASED collation with exceptions like:
      Caused by: org.apache.derby.client.am.SqlException: Comparisons between 'VARCHAR' and 'CHAR' are not supported.
      and can be seen when running lang/FullCollationTests.java

      It would be good to change the tests to use casts so that the queries succeed and the tests can complete.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: