[ https://issues.apache.org/jira/browse/CALCITE-3396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
jin xing updated CALCITE-3396: ------------------------------ 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. > Materialization matching succeeds when query and view are both of UNION but > have different 'all' property > --------------------------------------------------------------------------------------------------------- > > Key: CALCITE-3396 > URL: https://issues.apache.org/jira/browse/CALCITE-3396 > Project: Calcite > Issue Type: Bug > Components: core > Reporter: jin xing > Assignee: jin xing > Priority: Major > > *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. -- This message was sent by Atlassian Jira (v8.3.4#803005)