[jira] [Created] (CALCITE-5668) When parsing SQL in PostgreSQL dialect, allow unquoted table names to contain dollar sign

["Dmitry Sysolyatin (Jira)" <ji...@apache.org>]

Dmitry Sysolyatin created CALCITE-5668:
------------------------------------------

             Summary: 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


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



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