[jira] [Commented] (CALCITE-1586) wrong rel-to-sql conversion when performing set operation more then two inputs.

["Zhiqiang He (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-1586?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15827502#comment-15827502 ] 

Zhiqiang He commented on CALCITE-1586:
--------------------------------------

https://github.com/apache/calcite/pull/353
[~julianhyde] please review it. thanks.

> wrong rel-to-sql conversion when performing set operation more then two inputs.
> -------------------------------------------------------------------------------
>
>                 Key: CALCITE-1586
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1586
>             Project: Calcite
>          Issue Type: Bug
>          Components: jdbc-adapter
>    Affects Versions: 1.10.0
>         Environment: NA
>            Reporter: Zhiqiang He
>            Assignee: Julian Hyde
>            Priority: Critical
>
> in union example, after UnionMergeRule, the union input is convert to three input, and rel to sql convert result is wrong.
> inputsql
>  {code:sql}
>  SELECT *
> FROM (SELECT \"product_id\"
> FROM \"foodmart\".\"product\"
> UNION ALL
> SELECT \"product_id\"
> FROM \"foodmart\".\"sales_fact_1997\")
> UNION ALL
> SELECT \"product_class_id\" AS \"PRODUCT_ID\"
> FROM \"foodmart\".\"product_class\"
>  {code}
> output sql
>  {code:sql}
> SELECT \"product_id\"
> FROM \"foodmart\".\"product\"
> UNION ALL
> SELECT \"product_id\"
> FROM \"foodmart\".\"sales_fact_199
>  {code}
> the lastest union query is lost.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)