[CALCITE-4767] JDBC adapter wrongly quotes backticks inside BigQuery identifiers

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.28.0
• Component/s: jdbc-adapter
• Labels: pull-request-available
• Assignee: Jack Scott
• Reporter: Jack Scott
• Created: 08/Sep/21 19:18
• Updated: 20/Oct/21 05:24
• Resolved: 20/Sep/21 04:55

Description

 

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.

Issue Links

• is related to: CALCITE-4847 Parse SQL with BigQuery-style quoted identifiers and character literals
• links to: Avatica PR 153
• links to: GitHub Pull Request #2527