[ 
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}
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. 

  was:
 
{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. 


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

Reply via email to