[CALCITE-3396] Materialization matching succeeds when query and view are both of UNION but have different 'all' property

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.22.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Jin Xing
• Reporter: Jin Xing
• Created: 10/Oct/19 09:16
• Updated: 06/Mar/20 04:35
• Resolved: 11/Oct/19 20:43

Description

Materialized-View:
select * from emps where empid < 300
union
select * from emps where empid > 200

Query:
select * from emps where empid < 300
union all
select * from emps where empid > 200

Above MV and Query have different 'all' property in UNION but they succeed matching now. 

Issue Links

• relates to: CALCITE-3214 Add UnionToUnionRule for materialization matching
• links to: GitHub Pull Request #1493