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