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

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

Volodymyr Vysotskyi created DRILL-7194:
------------------------------------------

             Summary: 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
            Reporter: Volodymyr Vysotskyi
             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)