[CALCITE-4847] Parse SQL with BigQuery-style quoted identifiers and character literals

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.28.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 12/Oct/21 06:34
• Updated: 20/Oct/21 05:24
• Resolved: 13/Oct/21 23:28

Description

Parse SQL with BigQuery-style quoted identifiers and character literals.

BigQuery quotes identifiers using backticks, escaping interior backticks using backslash. In CALCITE-4767 we added Quoting.BACK_TICK_BACKSLASH to distinguish this style from what MySQL does, namely Quoting.BACK_TICK.

BigQuery quotes character literals using double quotes, escaping interior double quotes using backslash. In CALCITE-4767 we added Quoting.DOUBLE_QUOTE_BACKSLASH to distinguish this style from Quoting.DOUBLE_QUOTE.

After this change, we should be able to parse the following query if we invoke the parser with lex=BIG_QUERY or dialect=BIG_QUERY:

SELECT "a \"quoted\" char literal"
FROM `a \`quoted\` table`

Issue Links

• relates to: CALCITE-4767 JDBC adapter wrongly quotes backticks inside BigQuery identifiers