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.postgresql.org/docs/11/sql-syntax-lexical.html#SQL-SYNTAX-COMMENTS
Feature ID: T351