This content has been marked as final.
Show 2 replies
-
1. Re: Facing issue while constraining on CLOB coulmn
rareddy Jun 23, 2017 7:26 AM (in response to aliahsan)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.
-
2. Re: Facing issue while constraining on CLOB coulmn
shawkins Jun 23, 2017 8:44 AM (in response to rareddy)There is a system property to allow direct clob comparisons as well org.teiid.comparableLobs - System Properties · Teiid Documentation