Yuming Wang created SPARK-28880:
-----------------------------------
Summary: ANSI SQL: Bracketed comments
Key: SPARK-28880
URL: https://issues.apache.org/jira/browse/SPARK-28880
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 3.0.0
Reporter: Yuming Wang
We can not support these bracketed comments:
*Case 1*:
{code:sql}
/* This is an example of SQL which should not execute:
* select 'multi-line';
*/
{code}
*Case 2*:
{code:sql}
/*
SELECT 'trailing' as x1; -- inside block comment
*/
{code}
*Case 3*:
{code:sql}
/* This block comment surrounds a query which itself has a block comment...
SELECT /* embedded single line */ 'embedded' AS x2;
*/
{code}
*Case 4*:
{code:sql}
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;
{code}
*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
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
