Jurgen Doll created CAY-2850:
--------------------------------
Summary: Query using Clob comparison with empty String fails
Key: CAY-2850
URL: https://issues.apache.org/jira/browse/CAY-2850
Project: Cayenne
Issue Type: Bug
Components: Core Library
Affects Versions: 4.2, 5.0-M2
Reporter: Jurgen Doll
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 !
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
