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

• 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
• Assignee: Mamta A. Satoor
• Reporter: Daniel John Debrunner
• Created: 03/Jul/07 22:25
• Updated: 16/Jan/08 13:02
• Resolved: 19/Jul/07 20:43

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.

Issue Links

• is related to: DERBY-2894 calling DatabaseMetaData.getColumns() with % for matching column character in a territory based collated db does not work in 1.4.2 jvms