Zoltan Haindrich created CALCITE-2929: -----------------------------------------
Summary: Simplification of IS NULL checks are incorrectly assuming that CAST-s are possible Key: CALCITE-2929 URL: https://issues.apache.org/jira/browse/CALCITE-2929 Project: Calcite Issue Type: Bug Reporter: Zoltan Haindrich Assignee: Zoltan Haindrich Example: {code} with ax(s) as (values ('xxx'),(cast(null as character varying))) select cast(s as int) IS NULL from ax; {code} returns a result set; which evaluates however 'xxx' is not a valid integer; so an error should be recieved instead Another class of almost the same issue: {code} select cast('xxx' as int) IS NULL; {code} is also problematic; in that case the not nullability is deduced from the fact that the literal's type is not nullable -- This message was sent by Atlassian JIRA (v7.6.3#76005)