2 Replies Latest reply on Jun 23, 2017 8:44 AM by shawkins

    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.