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)