YQL-19747: Support qualified asterisk

Support `SELECT x.* FROM t AS x`.
commit_hash:64693f65281f385d6c0d3541fb2874b0153aa88c

1 files changed, 34 insertions, 0 deletions

diff --git a/yql/essentials/sql/v1/complete/analysis/global/global_ut.cpp b/yql/essentials/sql/v1/complete/analysis/global/global_ut.cpp
index 15aba3ee155..830b3c2a9ee 100644
--- a/yql/essentials/sql/v1/complete/analysis/global/global_ut.cpp
+++ b/yql/essentials/sql/v1/complete/analysis/global/global_ut.cpp
@@ -203,6 +203,40 @@ Y_UNIT_TEST_SUITE(GlobalAnalysisTests) {
             };
             UNIT_ASSERT_VALUES_EQUAL(ctx.Column, expected);
         }
+        {
+            TString query = R"(
+                SELECT # FROM (
+                    SELECT x.*, y.name, e
+                    FROM (SELECT a.*, d FROM a AS a JOIN c AS c ON TRUE) AS x
+                    JOIN b AS y
+                )
+            )";
+
+            TGlobalContext ctx = global->Analyze(SharpedInput(query), {});
+
+            TColumnContext expected = {
+                .Tables = {
+                    TAliased<TTableId>("", {"", "a"}),
+                },
+                .Columns = {
+                    {.Name = "d"},
+                    {.Name = "e"},
+                },
+            };
+            UNIT_ASSERT_VALUES_EQUAL(ctx.Column, expected);
+        }
+        {
+            TString query = "SELECT # FROM (SELECT 1, *, 2 FROM t)";
+
+            TGlobalContext ctx = global->Analyze(SharpedInput(query), {});
+
+            TColumnContext expected = {
+                .Tables = {
+                    TAliased<TTableId>("", {"", "t"}),
+                },
+            };
+            UNIT_ASSERT_VALUES_EQUAL(ctx.Column, expected);
+        }
     }
 
     Y_UNIT_TEST(Projection) {