[jira] [Comment Edited] (BEAM-6810) [SQL] Plan optimizer eliminates aliasing in trivial projections

["Gleb Kanterov (JIRA)" <ji...@apache.org>]

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

Gleb Kanterov edited comment on BEAM-6810 at 3/12/19 10:48 AM:
---------------------------------------------------------------

Possibly related to CALCITE-1584


was (Author: kanterov):
Possibly related to https://issues.apache.org/jira/browse/CALCITE-1584

> [SQL] Plan optimizer eliminates aliasing in trivial projections
> ---------------------------------------------------------------
>
>                 Key: BEAM-6810
>                 URL: https://issues.apache.org/jira/browse/BEAM-6810
>             Project: Beam
>          Issue Type: Bug
>          Components: dsl-sql
>    Affects Versions: 2.11.0
>            Reporter: Gleb Kanterov
>            Assignee: Gleb Kanterov
>            Priority: Major
>             Fix For: 2.12.0
>
>
> Trivial projection is a projection that uses all input columns and doesn't re-order them. Simplest example is:
> {code}
> SELECT * FROM PCOLLECTION
> {code}
> Given input PCollection with a schema `c_int64: BIGINT` following query should result in PCollection with a schema `abc: BIGINT`, however, due to a bug in query optimization, it results in `c_int64: BIGINT`
> {code}
> SELECT c_int64 as abc FROM PCOLLECTION
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)