You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Vladimir Sitnikov (JIRA)" <ji...@apache.org> on 2018/09/20 08:03:00 UTC
[jira] [Updated] (CALCITE-2573) RexSimplify: simplify NULL to FALSE
in uknownAsFalse mode
[ https://issues.apache.org/jira/browse/CALCITE-2573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vladimir Sitnikov updated CALCITE-2573:
---------------------------------------
Description:
{noformat}2018-09-19 20:42:41,804 [pool-1-thread-1] INFO - Randomized test identified a potential defect. Feel free to fix that issue
java.lang.AssertionError: result mismatch: when applied to {}, null yielded NULL, and false yielded false
at org.apache.calcite.rex.RexSimplify.verify(RexSimplify.java:1208)
at org.apache.calcite.rex.RexSimplify.simplify(RexSimplify.java:178)
at org.apache.calcite.test.fuzzer.RexProgramFuzzyTest.checkTrueFalse(RexProgramFuzzyTest.java:169)
at org.apache.calcite.test.fuzzer.RexProgramFuzzyTest.checkTrueFalse(RexProgramFuzzyTest.java:160)
Suppressed: org.apache.calcite.test.fuzzer.RexProgramFuzzyTest$1: seed -4383181468718104148{noformat}
{noformat}postgres=# select * from (values(42)) as t where 42;
ERROR: argument of WHERE must be type boolean, not type integer
LINE 1: select * from (values(42)) as t where 42;
^
postgres=# select * from (values(42)) as t where cast(null as int4);
ERROR: argument of WHERE must be type boolean, not type integer
LINE 1: select * from (values(42)) as t where cast(null as int4);
^
postgres=# select * from (values(42)) as t where cast(null as bool);
column1
---------
(0 rows){noformat}
was:
{noformat}2018-09-19 20:42:41,804 [pool-1-thread-1] INFO - Randomized test identified a potential defect. Feel free to fix that issue
java.lang.AssertionError: result mismatch: when applied to {}, null yielded NULL, and false yielded false
at org.apache.calcite.rex.RexSimplify.verify(RexSimplify.java:1208)
at org.apache.calcite.rex.RexSimplify.simplify(RexSimplify.java:178)
at org.apache.calcite.test.fuzzer.RexProgramFuzzyTest.checkTrueFalse(RexProgramFuzzyTest.java:169)
at org.apache.calcite.test.fuzzer.RexProgramFuzzyTest.checkTrueFalse(RexProgramFuzzyTest.java:160)
Suppressed: org.apache.calcite.test.fuzzer.RexProgramFuzzyTest$1: seed -4383181468718104148{noformat}
> RexSimplify: simplify NULL to FALSE in uknownAsFalse mode
> ---------------------------------------------------------
>
> Key: CALCITE-2573
> URL: https://issues.apache.org/jira/browse/CALCITE-2573
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.17.0
> Reporter: Vladimir Sitnikov
> Assignee: Julian Hyde
> Priority: Major
> Labels: newbie
>
> {noformat}2018-09-19 20:42:41,804 [pool-1-thread-1] INFO - Randomized test identified a potential defect. Feel free to fix that issue
> java.lang.AssertionError: result mismatch: when applied to {}, null yielded NULL, and false yielded false
> at org.apache.calcite.rex.RexSimplify.verify(RexSimplify.java:1208)
> at org.apache.calcite.rex.RexSimplify.simplify(RexSimplify.java:178)
> at org.apache.calcite.test.fuzzer.RexProgramFuzzyTest.checkTrueFalse(RexProgramFuzzyTest.java:169)
> at org.apache.calcite.test.fuzzer.RexProgramFuzzyTest.checkTrueFalse(RexProgramFuzzyTest.java:160)
> Suppressed: org.apache.calcite.test.fuzzer.RexProgramFuzzyTest$1: seed -4383181468718104148{noformat}
> {noformat}postgres=# select * from (values(42)) as t where 42;
> ERROR: argument of WHERE must be type boolean, not type integer
> LINE 1: select * from (values(42)) as t where 42;
> ^
> postgres=# select * from (values(42)) as t where cast(null as int4);
> ERROR: argument of WHERE must be type boolean, not type integer
> LINE 1: select * from (values(42)) as t where cast(null as int4);
> ^
> postgres=# select * from (values(42)) as t where cast(null as bool);
> column1
> ---------
> (0 rows){noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)