[
https://issues.apache.org/jira/browse/CALCITE-3986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17147585#comment-17147585
]
Julian Hyde commented on CALCITE-3986:
--------------------------------------
[~dschmitt], I just created a test case in
[julianhyde/3986-redundant-alias|https://github.com/julianhyde/calcite/tree/3986-redundant-alias].
Current behavior (even without a config option) seems to be what you are
requesting. Can you please review?
> 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
> 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)
