[jira] [Commented] (FLINK-16609) Promotes the column name representation of SQL-CLI

["Kurt Young (Jira)" <ji...@apache.org>]

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

Kurt Young commented on FLINK-16609:
------------------------------------

It's a good improvement. +1 for this.

> Promotes the column name representation of SQL-CLI
> --------------------------------------------------
>
>                 Key: FLINK-16609
>                 URL: https://issues.apache.org/jira/browse/FLINK-16609
>             Project: Flink
>          Issue Type: Improvement
>          Components: Table SQL / Client
>    Affects Versions: 1.10.0
>            Reporter: Danny Chen
>            Priority: Major
>             Fix For: 1.11.0
>
>
> The SQL-CLI now outputs the column name as the name that comes from the plan, which is  not that readable sometimes, i can think of 2 cases that can be promoted:
> * Expression like "a + b" should output "a + b" (i.e. the MySQL CLI) instead of "$Expr{index}"
> * We should always output the alias if it's there, now, the alias in the plan may be dropped because of 2 reasons:
>     1. Project remove rule would remove the project without considering the alias
>     2. after CALCITE-3713, some CALC/PROJ would be reused while ignoring the column alias



--
This message was sent by Atlassian Jira
(v8.3.4#803005)