[
https://issues.apache.org/jira/browse/CAY-2850?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nikita Timofeev closed CAY-2850.
--------------------------------
Resolution: Fixed
> 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
> Priority: Minor
> Labels: pull-request-available
> Fix For: 4.2.1, 5.0-M1
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> 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)
