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

Ran Tao commented on CALCITE-5958:
----------------------------------

[~shenlang] hi Shen, FYI. value is sql reserved keywords from sql-92. We can 
not make it to nonReservedKeywords directly. how about make it only in PG 
library?

> Make the value be nonReservedKeywords(consistent with Postgres)
> ---------------------------------------------------------------
>
>                 Key: CALCITE-5958
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5958
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: LakeShen
>            Priority: Major
>         Attachments: image-2023-08-27-12-33-24-000.png, 
> image-2023-08-27-12-34-53-322.png
>
>
> Now in the Postgres, value could be field alias,for example:
> {code:java}
> select 1 + 1 as value {code}
> The above SQL was successfully executed in PG:
> !image-2023-08-27-12-33-24-000.png|width=275,height=210!
> In Calcite, the above SQL throws a parse error:
> !image-2023-08-27-12-34-53-322.png|width=554,height=197!
> I don't confirm whether this is a problem



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to