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

["Kathey Marsden (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-2962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden resolved DERBY-2962.
-----------------------------------

    Resolution: Fixed

I changed the tests that run with Suites.All (FullCollationTests) but not derbyall since we are not setup to test that except by checking out all the *app.property files. 



> Change functional tests to use casts for System table queries to avoid conversion errors when run with TERRITORY_BASED collation
> --------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2962
>                 URL: https://issues.apache.org/jira/browse/DERBY-2962
>             Project: Derby
>          Issue Type: Task
>    Affects Versions: 10.4.0.0
>            Reporter: Kathey Marsden
>            Assignee: Kathey Marsden
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.