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

Reply via email to