[ 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)