[
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)
