Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-4230

When parsing SQL in BigQuery dialect, split quoted table names that contain dots

    XMLWordPrintableJSON

Details

    Description

      When parsing SQL in BigQuery dialect, split quoted table names that contain dots. The following three are equivalent:

      select * from `bigquery-public-data`.`samples`.`natality`;
select * from `bigquery-public-data.samples.natality`;
select * from bigquery-public-data.samples.natality;

      After this change, Babel will return the same parse tree for all 3 queries. (The third will require CALCITE-4246.)

      To control this feature, in interface SqlConformance, add method boolean splitQuotedTableName().

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-4247 When parsing SQL in BigQuery dialect, character literals may be enclosed in single- or double-quotes, and use backslashes as escapes

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-4246 When parsing SQL in BigQuery dialect, allow unquoted table names to contain hyphens

          • Major - Major loss of function.
          • Closed
          links to

          Web Link GitHub Pull Request #2147

          Activity

            People

              julianhyde Julian Hyde
              julianhyde Julian Hyde
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 40m
                  40m