[SPARK-16644] constraints propagation may fail the query

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 2.0.1, 2.1.0
• Component/s: SQL
• Target Version/s: 2.0.1
• Assignee: Wenchen Fan
• Reporter: Wenchen Fan
• Created: 20/Jul/16 07:34
• Updated: 21/Jul/16 01:49
• Resolved: 21/Jul/16 01:48

Description

create table(a int, b int);
select
  a,
  max(b) as c1,
  b as c2
from tbl
where a = b
group by a, b
having c1 = 1

this query fails in 2.0, but works in 1.6

Issue Links

• links to: [Github] Pull Request #14281 (cloud-fan)