[jira] [Assigned] (CALCITE-3986) Provide config option to omit assigning an alias that is identical to its identifier.

["Julian Hyde (Jira)" <ji...@apache.org>]

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

Julian Hyde reassigned CALCITE-3986:
------------------------------------

    Assignee: Julian Hyde

> Provide config option to omit assigning an alias that is identical to its identifier.
> -------------------------------------------------------------------------------------
>
>                 Key: CALCITE-3986
>                 URL: https://issues.apache.org/jira/browse/CALCITE-3986
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: Drew Schmitt
>            Assignee: Julian Hyde
>            Priority: Minor
>
> The current alias assignment logic with the SqlValidator config option identifierExpansion() set to true will eagerly try to choose an alias, even if the alias name ends up being the same as the identifier itself. For example, it will assign the alias "foo" for the table "foo".
> It's nice to have alias assignment, but making it identical to the identifier doesn't always provide a whole lot of value and can make queries more verbose than they need to be.
> Suggest we add another SqlValidator config option (defaulted to the current behavior) to allow a caller to disable alias assignment in the cases that it would be identical to the identifier.



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