[DERBY-7148] SQL Error [20000] [38000]: The exception 'java.lang.NoSuchMethodError: 'boolean org.apache.derby.iapi.types.DataValueDescriptor.equals(boolean)'' was thrown while evaluating an expression.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.16.1.1, 10.17.1.0
• Component/s: SQL
• Urgency: Normal
• Issue & fix info: Repro attached, Workaround attached
• Bug behavior facts: Crash, Deviation from standard, Seen in production
• Assignee: Unassigned
• Reporter: Lukas Eder
• Created: 17/Nov/22 10:04
• Updated: 17/Nov/22 18:23

Description

Run this query:

SELECT 1 
FROM sysibm.SYSDUMMY1
WHERE 1 IS NULL OR COALESCE((1 = 2), false);

It produces this error:

SQL Error [20000] [38000]: The exception 'java.lang.NoSuchMethodError: 'boolean org.apache.derby.iapi.types.DataValueDescriptor.equals(boolean)'' was thrown while evaluating an expression.