Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 29 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/select/autogen_columns_conflict.sql b/yql/essentials/tests/sql/suites/select/autogen_columns_conflict.sql
new file mode 100644
index 0000000000..16c07dbbb6
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/select/autogen_columns_conflict.sql
@@ -0,0 +1,29 @@
+/* dq can not */
+/* dqfile can not */
+/* yt can not */
+/* postgres can not */
+
+$src = select <|column0:1|> as x;
+
+$src = select * from $src flatten columns;
+
+select 2, a.* from $src as a;
+
+select 2, 1 as column0;
+
+select 2, 1 as column0
+union all
+select 4, 3 as column0;
+
+
+select * from (select 1) as a join (select 1) as b using(column0);
+
+
+
+select
+
+  1 as a,
+  2 as b,
+  3, -- should be column2
+  4 as column1;
+