Oleg Zinoviev created DRILL-6722: ------------------------------------ Summary: Query from parket with case-then and scalar operation returns a wrong result Key: DRILL-6722 URL: https://issues.apache.org/jira/browse/DRILL-6722 Project: Apache Drill Issue Type: Bug Affects Versions: 1.14.0 Reporter: Oleg Zinoviev Attachments: correct.csv, result.csv
Steps to reproduce: 1) Create sample table: {code:sql} create table dfs.tmp.test as select 1 as a, 2 as b union all select 3 as a, 2 as b union all select 1 as a, 4 as b union all select 2 as a, 2 as b {code} 2) Execute query: {code:sql} select case when s.a > s.b then s.a else s.b end as b, abs(s.a - s.b) as d from dfs.tmp.test s {code} 3) Drill returns: [^result.csv] 4) Result of query without parquet: {code:sql} select case when s.a > s.b then s.a else s.b end as b, abs(s.a - s.b) as d from ( select 1 as a, 2 as b union all select 3 as a, 2 as b union all select 1 as a, 4 as b union all select 2 as a, 2 as b ) s {code} [^correct.csv] -- This message was sent by Atlassian JIRA (v7.6.3#76005)