[jira] [Comment Edited] (CALCITE-5191) Allow sort by alias in BigQuery

["Chunwei Lei (Jira)" <ji...@apache.org>]

    [ 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)