[
https://issues.apache.org/jira/browse/CALCITE-3396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-3396:
------------------------------------
Labels: pull-request-available (was: )
> 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
> Labels: pull-request-available
>
> {code:java}
> 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
> {code}
> 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)
