[
https://issues.apache.org/jira/browse/DERBY-7148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17635335#comment-17635335
]
Lukas Eder commented on DERBY-7148:
-----------------------------------
A workaround is to cast the COALESCE expression to BOOLEAN:
{code}
SELECT 1
FROM sysibm.SYSDUMMY1
WHERE 1 IS NULL OR CAST(COALESCE((1 = 2), false) AS BOOLEAN);
{code}
> SQL Error [20000] [38000]: The exception 'java.lang.NoSuchMethodError:
> 'boolean org.apache.derby.iapi.types.DataValueDescriptor.equals(boolean)''
> was thrown while evaluating an expression.
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-7148
> URL: https://issues.apache.org/jira/browse/DERBY-7148
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.16.1.1
> Reporter: Lukas Eder
> Priority: Major
>
> Run this query:
> {code}
> SELECT 1
> FROM sysibm.SYSDUMMY1
> WHERE 1 IS NULL OR COALESCE((1 = 2), false);
> {code}
> It produces this error:
> {quote}SQL Error [20000] [38000]: The exception 'java.lang.NoSuchMethodError:
> 'boolean org.apache.derby.iapi.types.DataValueDescriptor.equals(boolean)''
> was thrown while evaluating an expression.{quote}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
