In Sybase IQ 15.2, a query containing a subquery with no FROM clause, that also includes predicates involving LONG BINARY or LONG VARCHAR columns, returns an error, as Sybase IQ does not support predicates with these data types.
If you encounter this problem and need to maintain the behavior of versions prior to Sybase IQ 15.2, set the temporary option CIS_OPTION for the duration of the query:
SET TEMPORARY OPTION CIS_OPTION = 8
Do not set CIS_OPTION on a global basis, as this can adversely affect performance.
