[ https://issues.apache.org/jira/browse/CALCITE-4246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Hyde resolved CALCITE-4246. ---------------------------------- Fix Version/s: 1.26.0 Resolution: Fixed Fixed in [df571c9c|https://github.com/apache/calcite/commit/df571c9c629d35c3e91e70194854c609b25381d2]. > When parsing SQL in BigQuery dialect, allow unquoted table names to contain > hyphens > ----------------------------------------------------------------------------------- > > Key: CALCITE-4246 > URL: https://issues.apache.org/jira/browse/CALCITE-4246 > Project: Calcite > Issue Type: Bug > Components: babel > Reporter: Julian Hyde > Assignee: Julian Hyde > Priority: Major > Fix For: 1.26.0 > > > When parsing SQL in BigQuery dialect, allow unquoted table names to contain > hyphens. This feature was [added in May > 2020|https://www.reddit.com/r/bigquery/comments/fgk31y/new_in_bigquery_no_more_backticks_around_table/]. > For these purposes, "table names" are considered to be the first identifier > after FROM, JOIN, INSERT, UPDATE, DELETE, TABLE without an intervening SELECT > or SET. (Yeah, the rules are rather rigid, but to implement it we have to > shift lexical states in the parser, and we can only do that based on what > tokens we've seen. Hopefully the rules will suffice.) > Valid identifiers with hyphens: > * {{select * from bigquery-public-data.foo}} > * {{insert into bigquery-public-data.foo values (1)}} > * {{delete from bigquery-public-data.foo}} > * {{select * from dept cross join bigquery-public-data.foo}} > Invalid identifiers with hyphens: > * {{select foo-bar from dept}} # column names cannot have hyphens > * {{select * from dept as foo-bar}} # table aliases cannot have hyphens > * {{select foo-bar.deptno from dept as `foo-bar`}} # ditto > * {{select * from foo.bar-baz.bump}} # only first part of table name > In all of the above 'invalid' cases, you can solve by enclosing the > identifier with back-ticks, e.g. {{select `foo-bar` from dept}}. > To control this feature, in {{interface SqlConformance}}, add method > {{boolean allowHyphenInUnquotedTableName()}}. -- This message was sent by Atlassian Jira (v8.3.4#803005)