[jira] [Resolved] (CALCITE-3396) Materialization matching succeeds when query and view are both of UNION but have different 'all' property

["Haisheng Yuan (Jira)" <ji...@apache.org>]

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

Haisheng Yuan resolved CALCITE-3396.
------------------------------------
    Fix Version/s: 1.22.0
       Resolution: Fixed

Fixed in https://github.com/apache/calcite/commit/c7ab64688f611f599d3b0d07340680e968c7ccf8.

> 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
>             Fix For: 1.22.0
>
>          Time Spent: 1h 50m
>  Remaining Estimate: 0h
>
> {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)