[jira] [Updated] (DRILL-7194) Wrong result when non-deterministic functions are used in filter

["Volodymyr Vysotskyi (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-7194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Volodymyr Vysotskyi updated DRILL-7194:
---------------------------------------
    Affects Version/s: 1.15.0

> Wrong result when non-deterministic functions are used in filter
> ----------------------------------------------------------------
>
>                 Key: DRILL-7194
>                 URL: https://issues.apache.org/jira/browse/DRILL-7194
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.15.0
>            Reporter: Volodymyr Vysotskyi
>            Priority: Major
>             Fix For: Future
>
>
> Drill returns the wrong result when non-deterministic functions are used in filter condition, for example, the next query:
> {code:sql}
> select 1 from (values(1)) where random()=random();
> {code}
> returns
> {noformat}
> +--------+
> | EXPR$0 |
> +--------+
> | 1      |
> +--------+
> 1 row selected (0.105 seconds)
> {noformat}
> but {{random()=random()}} should be {{false}}, and therefore query shouldn't return any rows.
> If this condition is used in projection, it returns the correct result:
> {code:sql}
> select random()=random();
> {code}
> returns
> {noformat}
> +--------+
> | EXPR$0 |
> +--------+
> | false  |
> +--------+
> 1 row selected (1.558 seconds)
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)