Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
4.2, 5.0-M2
Description
When executing a query where the predicate contains something like CLOB_COL != '' then a CayenneRuntimeException is thrown with the cause being specified as "SQLSyntaxErrorException: precision or scale out of range".
This happens because the predicate gets translated into the following SQL: "cast( t0.CLOB_COL as varchar(0) )" where the varchar length is zero !