You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Dmitry Sysolyatin (Jira)" <ji...@apache.org> on 2023/04/21 12:42:00 UTC
[jira] [Updated] (CALCITE-5668) When parsing SQL in PostgreSQL dialect, allow unquoted table names to contain dollar sign
[ https://issues.apache.org/jira/browse/CALCITE-5668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dmitry Sysolyatin updated CALCITE-5668:
---------------------------------------
Description:
According PostgreSQL documentation [1]:
??SQL identifiers and key words must begin with a letter (a-z, but also letters with diacritical marks and non-Latin letters) or an underscore (_). Subsequent characters in an identifier or key word can be letters, underscores, digits (0-9), or dollar signs ($).??
To implement it, I suggest using the same approach as in CALCITE-4246.
[1] https://www.postgresql.org/docs/15/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
was:
According PostgreSQL documentation [1]:
??SQL identifiers and key words must begin with a letter (a-z, but also letters with diacritical marks and non-Latin letters) or an underscore (_). Subsequent characters in an identifier or key word can be letters, underscores, digits (0-9), or dollar signs ($).??
To implement it, I suggest using the same approach as in CALCITE-4246.
[1] https://www.postgresql.org/docs/8.1/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
> When parsing SQL in PostgreSQL dialect, allow unquoted table names to contain dollar sign
> -----------------------------------------------------------------------------------------
>
> Key: CALCITE-5668
> URL: https://issues.apache.org/jira/browse/CALCITE-5668
> Project: Calcite
> Issue Type: Bug
> Components: babel
> Affects Versions: 1.34.0
> Reporter: Dmitry Sysolyatin
> Priority: Major
>
> According PostgreSQL documentation [1]:
> ??SQL identifiers and key words must begin with a letter (a-z, but also letters with diacritical marks and non-Latin letters) or an underscore (_). Subsequent characters in an identifier or key word can be letters, underscores, digits (0-9), or dollar signs ($).??
> To implement it, I suggest using the same approach as in CALCITE-4246.
> [1] https://www.postgresql.org/docs/15/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
--
This message was sent by Atlassian Jira
(v8.20.10#820010)