[jira] [Commented] (CALCITE-4767) BigQuerySqlDialect uses the wrong identifier escape character

["Jack Scott (Jira)" <ji...@apache.org>]

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

Jack Scott commented on CALCITE-4767:
-------------------------------------

My initial plan is to add a new property "identifierEscapedQuote" to "SqlDialect" (along with all the associated methods) that would be essentially the same thing as the existing "literalEscapedQuote", but for identifiers instead of string literals.

> BigQuerySqlDialect uses the wrong identifier escape character
> -------------------------------------------------------------
>
>                 Key: CALCITE-4767
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4767
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Jack Scott
>            Assignee: Jack Scott
>            Priority: Minor
>
>  
> BigQuery Standard SQL uses backslashes to escape backticks in identifiers, e.g. `foo\`bar`, whereas the "identifierEscapedQuote" in Calcite's BigQuerySqlDialect is a double backtick, e.g. `foo``bar`, which does not work in BQ Standard SQL.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)