[jira] [Created] (DRILL-5237) Same query produces different/wrong results

["Serhii Harnyk (JIRA)" <ji...@apache.org>]

Serhii Harnyk created DRILL-5237:
------------------------------------

             Summary: Same query produces different/wrong results
                 Key: DRILL-5237
                 URL: https://issues.apache.org/jira/browse/DRILL-5237
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Serhii Harnyk
            Assignee: Serhii Harnyk


Query 
{code:sql}
select count(*) as col from (select t1.a.a1 from (select t.*, flatten(t.b) as b from dfs.`/tmp/test_data` t where t.c is not null) t1 where t1.a .a1 like 'a1');
{code}
returns different results for different values for option planner.width.max_per_node
With options 
{code:sql}
alter session set `planner.slice_target` = 1;
alter session set `planner.width.max_per_node` = 1;
{code}
query returns correct result:
{noformat}
+------+
| col  |
+------+
| 3    |
+------+
{noformat}
but with options 
{code:sql}
alter session set `planner.slice_target` = 1;
alter session set `planner.width.max_per_node` = 3;
{code}
the same query returns wrong result 
{noformat}
+------+
| col  |
+------+
| 2    |
+------+
{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)