[
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)
