[
https://issues.apache.org/jira/browse/CAY-2850?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17836906#comment-17836906
]
Jurgen Doll commented on CAY-2850:
----------------------------------
Created a [PR|https://github.com/apache/cayenne/pull/611]
> 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
> Time Spent: 10m
> 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)
