[ https://issues.apache.org/jira/browse/CALCITE-2929?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kevin Risden resolved CALCITE-2929. ----------------------------------- Resolution: Fixed merged in commit a648f9c12309cc253628930b0cab98591caa66ab > 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 > Affects Versions: 1.18.0 > Reporter: Zoltan Haindrich > Assignee: Zoltan Haindrich > Priority: Major > Labels: pull-request-available > Fix For: 1.19.0 > > Time Spent: 1h 20m > Remaining Estimate: 0h > > 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)