[
https://issues.apache.org/jira/browse/CALCITE-5191?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17554341#comment-17554341
]
Chunwei Lei edited comment on CALCITE-5191 at 6/15/22 1:51 AM:
---------------------------------------------------------------
The doc[1] has said that BigQuery supports alias in the ORDER BY clause.
[1]
https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#order_by_clause
was (Author: chunwei lei):
The doc[1] has said that BigQuery supports alias in the ORDER BY clause.
[1]https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#order_by_clause
> Allow sort by alias in BigQuery
> -------------------------------
>
> Key: CALCITE-5191
> URL: https://issues.apache.org/jira/browse/CALCITE-5191
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: Wenrui Meng
> Assignee: Wenrui Meng
> Priority: Major
> Fix For: 1.31.0
>
>
> {code:java}
> select 1 as a order by a {code}
> the above statement is valid in BigQuery, but failed in current validation
> flow due to allow alias not enabled for the BigQuery conformance.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
