[DERBY-2962] Change functional tests to use casts for System table queries to avoid conversion errors when run with TERRITORY_BASED collation

• 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
• Assignee: Katherine Marsden
• Reporter: Katherine Marsden
• Created: 19/Jul/07 21:16
• Updated: 14/Nov/07 22:39
• Resolved: 30/Jul/07 22:38

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.