[DRILL-6722] Query from parquet with case-then and arithmetic operation returns a wrong result

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.14.0
• Fix Version/s: 1.16.0
• Component/s: Execution - Codegen
• Assignee: Vova Vysotskyi
• Reporter: Oleg Zinoviev
• Created: 29/Aug/18 17:59
• Updated: 15/Mar/19 07:08
• Resolved: 15/Mar/19 07:08

Description

Steps to reproduce:
1) Create sample table:

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

2) Execute query:

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

3) Drill returns: result.csv

4) Result of query without parquet:

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

correct.csv

Issue Links

• is related to: DRILL-6524 Two CASE statements in projection influence results of each other