Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 65 insertions, 0 deletions

diff --git a/yql/essentials/tests/postgresql/cases/comments.out b/yql/essentials/tests/postgresql/cases/comments.out
new file mode 100644
index 0000000000..33f612e633
--- /dev/null
+++ b/yql/essentials/tests/postgresql/cases/comments.out
@@ -0,0 +1,65 @@
+--
+-- COMMENTS
+--
+SELECT 'trailing' AS first; -- trailing single line
+  first   
+----------
+ trailing
+(1 row)
+
+SELECT /* embedded single line */ 'embedded' AS second;
+  second  
+----------
+ embedded
+(1 row)
+
+SELECT /* both embedded and trailing single line */ 'both' AS third; -- trailing single line
+ third 
+-------
+ both
+(1 row)
+
+SELECT 'before multi-line' AS fourth;
+      fourth       
+-------------------
+ before multi-line
+(1 row)
+
+/* This is an example of SQL which should not execute:
+ * select 'multi-line';
+ */
+SELECT 'after multi-line' AS fifth;
+      fifth       
+------------------
+ after multi-line
+(1 row)
+
+--
+-- Nested comments
+--
+/*
+SELECT 'trailing' as x1; -- inside block comment
+*/
+/* This block comment surrounds a query which itself has a block comment...
+SELECT /* embedded single line */ 'embedded' AS x2;
+*/
+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;
+         sixth         
+-----------------------
+ deeply nested example
+(1 row)
+
+/* and this is the end of the file */