Facing issue while constraining on CLOB coulmn

[aliahsan]

HI,

I am getting following error when i try to apply constrain on java.sql.CLOB column. i.e.  select * from myEntity where clobColumn = 'some content';

Error: TEIID30492 Remote org.teiid.api.exception.query.QueryValidatorException: TEIID30492 Non-comparable expression of type clob cannot be used in comparison:

SQLState:  50000

ErrorCode: 30492

I am using teiid 9.1.1 in my project.

[rareddy]

Clob columns are not comparable directly in Teiid. You can try "where convert(clobColumn, string) = 'some content'" but note that string conversion truncates the sting length to 4000 chars by default.

[shawkins]

There is a system property to allow direct clob comparisons as well org.teiid.comparableLobs - System Properties · Teiid Documentation