[DERBY-2656] Run suites.All against a collated database

• Type: Task
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.3.1.4
• Fix Version/s: 10.3.1.4
• Component/s: Test
• Assignee: Katherine Marsden
• Reporter: Katherine Marsden
• Created: 15/May/07 20:34
• Updated: 17/Aug/07 22:37
• Resolved: 25/Jul/07 00:51

Description

It would be good to leverage the existing tests to exercise the collation code. Investigate running all the tests against a collated database.

Kathey

Issue Links

• is blocked by: DERBY-2966 rs.moveToInsertRow() causes loss of connection with TERRITORY_BASED collation.
• is blocked by: DERBY-2659 CONSTANT_Utf8_info: java.lang.ClassCastException on select with a collated database
• is blocked by: DERBY-2959 create table ... as select ... from systemtable with no data fails even when there is no character string type involved. This happens in a territory based database
• relates to: DERBY-2973 With collation TERRITORY_BASED, insert into table after changing type of column causes assert failure and loss of connection
• relates to: DERBY-2950 BatchUpdateTest.testMinimalDDLInBatch Fails when run with collation with exception: java.sql.SQLException: Operand of LIKE predicate with type VARCHAR(128) and collation UCS_BASIC is not compatable with LIKE pattern operand with type CHAR(4) and collation
• relates to: DERBY-2951 BatchUpdateTest.testAssociatedParams test fails with collation with exception: Java exception: 'ASSERT FAILED type of inserted column[0] = org.apache.derby.iapi.types.CollatorSQLChartype of template column[0] = org.apache.derby.iapi.types.SQLChar:
• relates to: DERBY-2955 ERROR 42ZA2 creating table with check constraint with literal comparison
• relates to: DERBY-2956 With a collated database USER cannot be used in query against user tables without cast
• relates to: DERBY-2960 Group by substr() on collated database causes ERROR XJ001: Java exception: 'ASSERT FAILED col1.getClass() (class org.apache.derby.iapi.types.SQLVarchar) expected to be the same as col2.getClass() (class org.apache.derby.iapi.types.CollatorSQLVarchar):
• relates to: DERBY-2961 TriggerTest.testTypesINActionStatement fails with 'ASSERT FAILED col1.getClass() (class org.apache.derby.iapi.types.SQLClob) expected to be the same as col2.getClass() (class org.apache.derby.iapi.types.CollatorSQLClob)
• relates to: DERBY-2964 ASSERT FAILED type of inserted column[0] = org.apache.derby.iapi.types.SQLVarchar type of template column[0] = org.apache.derby.iapi.types.CollatorSQLVarchar when inserting row into table that has been modified with unique constraint
• relates to: DERBY-2972 Update or select with function in the where clause causes with TERRITORY_BASED collation fails with ERROR 42818: Comparisons between 'VARCHAR' and 'VARCHAR' are not supported.