Mihai Budiu created CALCITE-7896:
------------------------------------
Summary: Quantified queries on ROW values are not three-valued
Key: CALCITE-7896
URL: https://issues.apache.org/jira/browse/CALCITE-7896
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.42.0
Reporter: Mihai Budiu
{color:#3b3b3b}ROW comparisons with {color}{{{}<{}}}{color:#3b3b3b},
{color}{{{}<={}}}{color:#3b3b3b}, {color}{{{}>{}}}{color:#3b3b3b},
{color}{{>=}}{color:#3b3b3b} return TRUE or FALSE instead of UNKNOWN when a
field is NULL{color}
Quidem test which produces incorrect results:
{code:java}
select (1, 3) < (1, cast(null as int)) as lt1,
(1, cast(null as int)) < (1, 2) as lt2,
(cast(null as int), 1) < (1, 2) as lt3,
(1, cast(null as int)) < (2, 0) as lt4,
(1, 3) > (1, cast(null as int)) as gt1,
(1, 3) <= (1, cast(null as int)) as le1,
(1, 3) >= (1, cast(null as int)) as ge1;{code}
None of the results is NULL.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
