Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-1496

Problem in derby: comparison operators are not supported on Clob object values.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.0
    • 3.0.2
    • None
    • None

    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)

      Attachments

        Activity

          People

            cayenne_olga Olga Tkacheva
            cayenne_olga Olga Tkacheva
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: