You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Steven Talbot (JIRA)" <ji...@apache.org> on 2019/06/25 18:26:00 UTC
[jira] [Updated] (CALCITE-3147) BigQuery (standard SQL) quoting and
identifier issues
[ https://issues.apache.org/jira/browse/CALCITE-3147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Talbot updated CALCITE-3147:
-----------------------------------
Description:
BigQuery escapes single quotes with backticks, and requires triple-quote quoting (like Python) when there is a newline. Also, it does not support the same set of characters in identifiers as other dialects of SQL. For example, it does not support '$'. Ideally, RelToSqlConverter (with the logic of the BigQuery dialect) would handle all this.
> BigQuery (standard SQL) quoting and identifier issues
> -----------------------------------------------------
>
> Key: CALCITE-3147
> URL: https://issues.apache.org/jira/browse/CALCITE-3147
> Project: Calcite
> Issue Type: Bug
> Reporter: Steven Talbot
> Priority: Major
>
> BigQuery escapes single quotes with backticks, and requires triple-quote quoting (like Python) when there is a newline. Also, it does not support the same set of characters in identifiers as other dialects of SQL. For example, it does not support '$'. Ideally, RelToSqlConverter (with the logic of the BigQuery dialect) would handle all this.
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)