[ 
https://issues.apache.org/jira/browse/CALCITE-3396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

jin xing updated CALCITE-3396:
------------------------------
    Description: 
 
{code:java}

{code}
*Materialized View:*
{code:java}
select * from emps where empid < 300
union
{code}
 
** 
{code:java}
select * from emps where empid > 200
{code}


*Query:*
{code:java}
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. 

  was:
*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
>
>  
> {code:java}
> {code}
> *Materialized View:*
> {code:java}
> select * from emps where empid < 300
> union
> {code}
>  
> ** 
> {code:java}
> select * from emps where empid > 200
> {code}
> *Query:*
> {code:java}
> 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)

Reply via email to