[DERBY-6567] Incorrect nullability for CASE expression with parameter

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.10.2.0
• Fix Version/s: 10.10.2.1, 10.11.1.1
• Component/s: SQL
• Issue & fix info: Repro attached
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 08/May/14 14:34
• Updated: 09/Sep/16 09:54
• Resolved: 15/Oct/14 16:29

Description

This JUnit test code fails because it detects that the query returns null even though the result column is reported as not nullable:

        PreparedStatement ps = prepareStatement(
                "values case when false then 1 else ? end");
        ps.setNull(1, Types.INTEGER);
        JDBC.assertSingleValueResultSet(ps.executeQuery(), null);

Issue Links

• relates to: DERBY-6759 Derby 10.10 backport issue (fall 2014)