Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.0
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:
      None

      Description

      Spark SQL support these bracketed comments:
      Case 1:

      /* This is an example of SQL which should not execute:
       * select 'multi-line';
       */
      

      Case 2:

      /*
      SELECT 'trailing' as x1; -- inside block comment
      */
      

      But Spark SQL not support nested bracketed comments show below:

      Case 3:

      /* This block comment surrounds a query which itself has a block comment...
      SELECT /* embedded single line */ 'embedded' AS x2;
      */
      

      Case 4:

      SELECT -- continued after the following block comments...
      /* Deeply nested comment.
         This includes a single apostrophe to make sure we aren't decoding this part as a string.
      SELECT 'deep nest' AS n1;
      /* Second level of nesting...
      SELECT 'deeper nest' as n2;
      /* Third level of nesting...
      SELECT 'deepest nest' as n3;
      */
      Hoo boy. Still two deep...
      */
      Now just one deep...
      */
      'deeply nested example' AS sixth;
      

      bracketed comments
      Bracketed comments are introduced by /* and end with */. 

      https://www.ibm.com/support/knowledgecenter/en/SSCJDQ/com.ibm.swg.im.dashdb.sql.ref.doc/doc/c0056402.html

      https://www.postgresql.org/docs/11/sql-syntax-lexical.html#SQL-SYNTAX-COMMENTS
      Feature ID:  T351

        Attachments

          Activity

            People

            • Assignee:
              beliefer jiaan.geng
              Reporter:
              yumwang Yuming Wang
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: