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)
