Merge pull request #11788 from ydb-platform/mergelibs-241120-1113

Library import 241120-1113

23 files changed, 76 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_join.cfg b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_join.cfg
new file mode 100644
index 0000000000..eb2e5315d1
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_join.cfg
@@ -0,0 +1 @@
+xfail
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_join.sql b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_join.sql
new file mode 100644
index 0000000000..50a8ce4e63
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_join.sql
@@ -0,0 +1,8 @@
+--!syntax_pg
+select a.x + 1 as y, b.x + 1 as z from 
+    ((select 1 x) a
+    join
+    (select 1 x) b
+    on a.x = b.x)
+order by x+1
+-- column reference "x" is ambiguous
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_table.cfg b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_table.cfg
new file mode 100644
index 0000000000..eb2e5315d1
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_table.cfg
@@ -0,0 +1 @@
+xfail
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_table.sql b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_table.sql
new file mode 100644
index 0000000000..08260c4911
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_from_table.sql
@@ -0,0 +1,5 @@
+--!syntax_pg
+select a.* from 
+    (select 1 x, 2 x) a
+order by x
+-- ORDER BY "x" is ambiguous
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_item_expression_from_projection.cfg b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_item_expression_from_projection.cfg
new file mode 100644
index 0000000000..eb2e5315d1
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_item_expression_from_projection.cfg
@@ -0,0 +1 @@
+xfail
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_item_expression_from_projection.sql b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_item_expression_from_projection.sql
new file mode 100644
index 0000000000..7efb496218
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_item_expression_from_projection.sql
@@ -0,0 +1,4 @@
+--!syntax_pg
+select x + 1 as y, x - 1 as y from 
+    (select 1 x) a
+order by y+1
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_with_duplicates.cfg b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_with_duplicates.cfg
new file mode 100644
index 0000000000..eb2e5315d1
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_with_duplicates.cfg
@@ -0,0 +1 @@
+xfail
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_with_duplicates.sql b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_with_duplicates.sql
new file mode 100644
index 0000000000..9ceb4a1e41
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_with_duplicates.sql
@@ -0,0 +1,5 @@
+--!syntax_pg
+select x + 1 as y, x - 1 as y from 
+    (select 1 x) a
+order by y
+-- order by y is ambigous
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_wo_duplicated_in_projection.cfg b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_wo_duplicated_in_projection.cfg
new file mode 100644
index 0000000000..eb2e5315d1
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_wo_duplicated_in_projection.cfg
@@ -0,0 +1 @@
+xfail
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_wo_duplicated_in_projection.sql b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_wo_duplicated_in_projection.sql
new file mode 100644
index 0000000000..f27341fb2b
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_order_by_wo_duplicated_in_projection.sql
@@ -0,0 +1,5 @@
+--!syntax_pg
+select z from 
+    (select 1 x, 1 x, 3 z) a
+order by x
+-- column reference "x" is ambiguous
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_ref.cfg b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_ref.cfg
new file mode 100644
index 0000000000..5dae597903
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_ref.cfg
@@ -0,0 +1 @@
+xfail
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_ref.sql b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_ref.sql
new file mode 100644
index 0000000000..22098666df
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/ambigous_ref.sql
@@ -0,0 +1,2 @@
+--!syntax_pg
+select a.x from (select 1 x, 2 x) a
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/default.cfg b/yql/essentials/tests/sql/suites/pg_duplicated/default.cfg
new file mode 100644
index 0000000000..e69de29bb2
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/default.cfg
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/order_by_duplicated_proj_on_column_ref.sql b/yql/essentials/tests/sql/suites/pg_duplicated/order_by_duplicated_proj_on_column_ref.sql
new file mode 100644
index 0000000000..c7bc20ea1f
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/order_by_duplicated_proj_on_column_ref.sql
@@ -0,0 +1,5 @@
+--!syntax_pg
+select x + 1 as y, x + 1 as y from 
+    (select 1 x) a
+order by y
+-- [2, 2]
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/order_by_with_duplicates.sql b/yql/essentials/tests/sql/suites/pg_duplicated/order_by_with_duplicates.sql
new file mode 100644
index 0000000000..4a971632a8
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/order_by_with_duplicates.sql
@@ -0,0 +1,5 @@
+--!syntax_pg
+select x + 1 as y, x + 1 as y from 
+    (select 1 x) a
+order by y
+-- 2, 2
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/order_by_with_same_projection_lambda.sql b/yql/essentials/tests/sql/suites/pg_duplicated/order_by_with_same_projection_lambda.sql
new file mode 100644
index 0000000000..47507529b2
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/order_by_with_same_projection_lambda.sql
@@ -0,0 +1,5 @@
+--!syntax_pg
+select x + 1 as y, x + 1 as z from 
+    (select 1 x) a
+order by x+1
+-- [2,2]
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/qualified_star_from_using.sql b/yql/essentials/tests/sql/suites/pg_duplicated/qualified_star_from_using.sql
new file mode 100644
index 0000000000..a0045b7863
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/qualified_star_from_using.sql
@@ -0,0 +1,8 @@
+--!syntax_pg
+select a.*, b.* from 
+(
+    (select 1 x) a
+    full join
+    (select 2 x) b
+    using(x)
+)
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/qualified_star_proj.sql b/yql/essentials/tests/sql/suites/pg_duplicated/qualified_star_proj.sql
new file mode 100644
index 0000000000..f082c48984
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/qualified_star_proj.sql
@@ -0,0 +1,4 @@
+--!syntax_pg
+select a.*, c.* from 
+(select 1 x, 2 x) a,
+(select 3 x, 4 x) c
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/qualified_star_proj_three_times.sql b/yql/essentials/tests/sql/suites/pg_duplicated/qualified_star_proj_three_times.sql
new file mode 100644
index 0000000000..a6b6cfa1af
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/qualified_star_proj_three_times.sql
@@ -0,0 +1,4 @@
+--!syntax_pg
+select a.*, c.*, a.* from 
+(select '1' x, 2 x) a,
+(select 3 x, '4' x) c
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/qualified_star_proj_two_times.sql b/yql/essentials/tests/sql/suites/pg_duplicated/qualified_star_proj_two_times.sql
new file mode 100644
index 0000000000..c2fd10c145
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/qualified_star_proj_two_times.sql
@@ -0,0 +1,2 @@
+--!syntax_pg
+select a.*, a.* from  (select 1 x, 2 x) a
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/simple_duplicate.sql b/yql/essentials/tests/sql/suites/pg_duplicated/simple_duplicate.sql
new file mode 100644
index 0000000000..f1c0010b2a
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/simple_duplicate.sql
@@ -0,0 +1,2 @@
+--!syntax_pg
+select 1 a, '2' a
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/star_from_crossjoin.sql b/yql/essentials/tests/sql/suites/pg_duplicated/star_from_crossjoin.sql
new file mode 100644
index 0000000000..87cf83ac09
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/star_from_crossjoin.sql
@@ -0,0 +1,4 @@
+--!syntax_pg
+select * from 
+(select '1' x, 2 x) a,
+(select 3 x, '4' x) c
\ No newline at end of file
diff --git a/yql/essentials/tests/sql/suites/pg_duplicated/star_proj.sql b/yql/essentials/tests/sql/suites/pg_duplicated/star_proj.sql
new file mode 100644
index 0000000000..065b56014e
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg_duplicated/star_proj.sql
@@ -0,0 +1,2 @@
+--!syntax_pg
+select * from (select 1 a, 2 a) d
\ No newline at end of file