[CAY-1496] Problem in derby: comparison operators are not supported on Clob object values.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0
• Fix Version/s: 3.0.2
• Assignee: Olga Tkacheva
• Reporter: Olga Tkacheva
• Created: 18/Oct/10 10:21
• Updated: 19/Oct/10 11:51
• Resolved: 19/Oct/10 11:51

Description

If we try run select query look like

select * from t where a = b;
or
select * from t where a = 'some text';

where a, b - Clob value

[java] java.sql.SQLSyntaxErrorException: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
[java] at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
[java] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
[java] at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
[java] at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
[java] at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
[java] at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)