SeqMode support

commit_hash:3d0e8bfb46470e6ac36b0d198cfa1723c665f643

14 files changed, 41 insertions, 31 deletions

diff --git a/yql/essentials/tests/sql/minirun/part1/canondata/result.json b/yql/essentials/tests/sql/minirun/part1/canondata/result.json
index ba9522c7007..7daa80411c0 100644
--- a/yql/essentials/tests/sql/minirun/part1/canondata/result.json
+++ b/yql/essentials/tests/sql/minirun/part1/canondata/result.json
@@ -1407,9 +1407,9 @@
     ],
     "test.test[seq_mode-shared_named_expr-default.txt-Debug]": [
         {
-            "checksum": "2642f74cf83abb830bc9a34e330538ab",
-            "size": 294,
-            "uri": "https://{canondata_backend}/1946324/0c7df8431ce91c6d22f80f9e79930b7889ed7d59/resource.tar.gz#test.test_seq_mode-shared_named_expr-default.txt-Debug_/opt.yql"
+            "checksum": "6de9752b20a85eb7d5c4b1508dfd607d",
+            "size": 468,
+            "uri": "https://{canondata_backend}/1775319/c65a60e6521b0b2727aeaaf63f83ed91538f899e/resource.tar.gz#test.test_seq_mode-shared_named_expr-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[seq_mode-shared_named_expr-default.txt-Results]": [
@@ -1421,9 +1421,9 @@
     ],
     "test.test[seq_mode-simple1-default.txt-Debug]": [
         {
-            "checksum": "76c62609ce5d6987327f1591d43ce37d",
-            "size": 223,
-            "uri": "https://{canondata_backend}/1946324/0c7df8431ce91c6d22f80f9e79930b7889ed7d59/resource.tar.gz#test.test_seq_mode-simple1-default.txt-Debug_/opt.yql"
+            "checksum": "48f3616114ae8a8299cd0c8a80f39ad4",
+            "size": 357,
+            "uri": "https://{canondata_backend}/1775319/c65a60e6521b0b2727aeaaf63f83ed91538f899e/resource.tar.gz#test.test_seq_mode-simple1-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[seq_mode-simple1-default.txt-Results]": [
diff --git a/yql/essentials/tests/sql/minirun/part5/canondata/result.json b/yql/essentials/tests/sql/minirun/part5/canondata/result.json
index f09bd9e9d40..10aae642580 100644
--- a/yql/essentials/tests/sql/minirun/part5/canondata/result.json
+++ b/yql/essentials/tests/sql/minirun/part5/canondata/result.json
@@ -1875,9 +1875,9 @@
     ],
     "test.test[seq_mode-simple2-default.txt-Debug]": [
         {
-            "checksum": "11f71faa9d39b692597688bc20efe535",
-            "size": 326,
-            "uri": "https://{canondata_backend}/1775059/14cc3f85e8b99d225f6a229799a875409c914b0e/resource.tar.gz#test.test_seq_mode-simple2-default.txt-Debug_/opt.yql"
+            "checksum": "51d505ea4c89a20ead983ddf58b5250d",
+            "size": 500,
+            "uri": "https://{canondata_backend}/1775319/8312c490faca317de336a19d845024c92a7063d5/resource.tar.gz#test.test_seq_mode-simple2-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[seq_mode-simple2-default.txt-Results]": [
@@ -1889,9 +1889,9 @@
     ],
     "test.test[seq_mode-subquery_shared_subquery-default.txt-Debug]": [
         {
-            "checksum": "b1684817fcb396d524938f11cf23f83b",
-            "size": 165,
-            "uri": "https://{canondata_backend}/1889210/cfdbe69f4555efdc44a940b501c4d551d32d59cc/resource.tar.gz#test.test_seq_mode-subquery_shared_subquery-default.txt-Debug_/opt.yql"
+            "checksum": "eee0ffcaf655b9b6d369ec675d5e3dd0",
+            "size": 297,
+            "uri": "https://{canondata_backend}/1775319/8312c490faca317de336a19d845024c92a7063d5/resource.tar.gz#test.test_seq_mode-subquery_shared_subquery-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[seq_mode-subquery_shared_subquery-default.txt-Results]": [
diff --git a/yql/essentials/tests/sql/minirun/part8/canondata/result.json b/yql/essentials/tests/sql/minirun/part8/canondata/result.json
index 2e42891af21..7a0419c0163 100644
--- a/yql/essentials/tests/sql/minirun/part8/canondata/result.json
+++ b/yql/essentials/tests/sql/minirun/part8/canondata/result.json
@@ -1561,9 +1561,9 @@
     ],
     "test.test[seq_mode-shared_subquery_expr-default.txt-Debug]": [
         {
-            "checksum": "337165dd15b27237457781df32eaf9b5",
-            "size": 268,
-            "uri": "https://{canondata_backend}/1937429/f07d607c2797952b0e405c5e49adc94025f9df81/resource.tar.gz#test.test_seq_mode-shared_subquery_expr-default.txt-Debug_/opt.yql"
+            "checksum": "c586f99b0ac6dde9d43012f4d9af0865",
+            "size": 352,
+            "uri": "https://{canondata_backend}/1130705/5474fe1be194e0244a73036ccf0ae9718d4bcbfc/resource.tar.gz#test.test_seq_mode-shared_subquery_expr-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[seq_mode-shared_subquery_expr-default.txt-Results]": [
diff --git a/yql/essentials/tests/sql/sql2yql/canondata/result.json b/yql/essentials/tests/sql/sql2yql/canondata/result.json
index 85601647767..31bc9a4a2b5 100644
--- a/yql/essentials/tests/sql/sql2yql/canondata/result.json
+++ b/yql/essentials/tests/sql/sql2yql/canondata/result.json
@@ -7897,37 +7897,37 @@
     ],
     "test_sql2yql.test[seq_mode-shared_named_expr]": [
         {
-            "checksum": "7f16d29d01ed38006249f8a6df896d89",
-            "size": 2162,
-            "uri": "https://{canondata_backend}/1937150/ec0019724df75083b0e89cab22f57e10ef36744e/resource.tar.gz#test_sql2yql.test_seq_mode-shared_named_expr_/sql.yql"
+            "checksum": "1bc276a9cb08e31273e24da9ad90582d",
+            "size": 2291,
+            "uri": "https://{canondata_backend}/1925842/cfa71598e75c768c65a88908e736e1530b7d43ce/resource.tar.gz#test_sql2yql.test_seq_mode-shared_named_expr_/sql.yql"
         }
     ],
     "test_sql2yql.test[seq_mode-shared_subquery_expr]": [
         {
-            "checksum": "442af621c99f97281cb191ad5121a040",
-            "size": 2759,
-            "uri": "https://{canondata_backend}/1937150/ec0019724df75083b0e89cab22f57e10ef36744e/resource.tar.gz#test_sql2yql.test_seq_mode-shared_subquery_expr_/sql.yql"
+            "checksum": "9422f76b560ea5ecdcb0327e9c9e4ed3",
+            "size": 2888,
+            "uri": "https://{canondata_backend}/1925842/cfa71598e75c768c65a88908e736e1530b7d43ce/resource.tar.gz#test_sql2yql.test_seq_mode-shared_subquery_expr_/sql.yql"
         }
     ],
     "test_sql2yql.test[seq_mode-simple1]": [
         {
-            "checksum": "1f0db2592f2b598f5aed44db4a3e1133",
-            "size": 1269,
-            "uri": "https://{canondata_backend}/1937150/ec0019724df75083b0e89cab22f57e10ef36744e/resource.tar.gz#test_sql2yql.test_seq_mode-simple1_/sql.yql"
+            "checksum": "48fb00e55120b60eb11fa6cf1061c504",
+            "size": 1398,
+            "uri": "https://{canondata_backend}/1925842/cfa71598e75c768c65a88908e736e1530b7d43ce/resource.tar.gz#test_sql2yql.test_seq_mode-simple1_/sql.yql"
         }
     ],
     "test_sql2yql.test[seq_mode-simple2]": [
         {
-            "checksum": "20c533355047f0b26cbf19786e4dcb3b",
-            "size": 2124,
-            "uri": "https://{canondata_backend}/1937150/ec0019724df75083b0e89cab22f57e10ef36744e/resource.tar.gz#test_sql2yql.test_seq_mode-simple2_/sql.yql"
+            "checksum": "eb5d04c76da927a4a883b6545ccbd960",
+            "size": 2253,
+            "uri": "https://{canondata_backend}/1925842/cfa71598e75c768c65a88908e736e1530b7d43ce/resource.tar.gz#test_sql2yql.test_seq_mode-simple2_/sql.yql"
         }
     ],
     "test_sql2yql.test[seq_mode-subquery_shared_subquery]": [
         {
-            "checksum": "0da75f9a85034564b31a4f5679b6685b",
-            "size": 2377,
-            "uri": "https://{canondata_backend}/1937150/ec0019724df75083b0e89cab22f57e10ef36744e/resource.tar.gz#test_sql2yql.test_seq_mode-subquery_shared_subquery_/sql.yql"
+            "checksum": "08becfe4d405df78f6cc4dd857d39326",
+            "size": 2204,
+            "uri": "https://{canondata_backend}/1925842/cfa71598e75c768c65a88908e736e1530b7d43ce/resource.tar.gz#test_sql2yql.test_seq_mode-subquery_shared_subquery_/sql.yql"
         }
     ],
     "test_sql2yql.test[side_effects-convert_empty_dict_to_dict]": [
diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-shared_named_expr_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-shared_named_expr_/formatted.sql
index d53c7c38f25..cf870088f09 100644
--- a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-shared_named_expr_/formatted.sql
+++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-shared_named_expr_/formatted.sql
@@ -1,4 +1,5 @@
 PRAGMA SeqMode;
+PRAGMA config.flags('DisableEarlyExpandSeq');
 PRAGMA CompactNamedExprs;
 
 $a = 1;
diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-shared_subquery_expr_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-shared_subquery_expr_/formatted.sql
index ba58a0f0e44..53b316dd42c 100644
--- a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-shared_subquery_expr_/formatted.sql
+++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-shared_subquery_expr_/formatted.sql
@@ -1,4 +1,5 @@
 PRAGMA SeqMode;
+PRAGMA config.flags('DisableEarlyExpandSeq');
 
 $a = (
     SELECT
diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-simple1_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-simple1_/formatted.sql
index 4b6398d23f0..b139fc65302 100644
--- a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-simple1_/formatted.sql
+++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-simple1_/formatted.sql
@@ -1,4 +1,5 @@
 PRAGMA SeqMode;
+PRAGMA config.flags('DisableEarlyExpandSeq');
 
 SELECT
     1
diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-simple2_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-simple2_/formatted.sql
index dc692e1f7d9..97d57b3bfa6 100644
--- a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-simple2_/formatted.sql
+++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-simple2_/formatted.sql
@@ -1,4 +1,5 @@
 PRAGMA SeqMode;
+PRAGMA config.flags('DisableEarlyExpandSeq');
 
 SELECT
     1
diff --git a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-subquery_shared_subquery_/formatted.sql b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-subquery_shared_subquery_/formatted.sql
index e1aeecce660..04bea17b6b4 100644
--- a/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-subquery_shared_subquery_/formatted.sql
+++ b/yql/essentials/tests/sql/sql2yql/canondata/test_sql_format.test_seq_mode-subquery_shared_subquery_/formatted.sql
@@ -1,4 +1,5 @@
 PRAGMA SeqMode;
+PRAGMA config.flags('DisableEarlyExpandSeq');
 
 DEFINE SUBQUERY $a() AS
     $r = (
diff --git a/yql/essentials/tests/sql/suites/seq_mode/shared_named_expr.yql b/yql/essentials/tests/sql/suites/seq_mode/shared_named_expr.yql
index 160f41fc1a9..52def76ffeb 100644
--- a/yql/essentials/tests/sql/suites/seq_mode/shared_named_expr.yql
+++ b/yql/essentials/tests/sql/suites/seq_mode/shared_named_expr.yql
@@ -1,4 +1,5 @@
 pragma SeqMode;
+pragma config.flags("DisableEarlyExpandSeq");
 pragma CompactNamedExprs;
 $a = 1;
 select $a;
diff --git a/yql/essentials/tests/sql/suites/seq_mode/shared_subquery_expr.yql b/yql/essentials/tests/sql/suites/seq_mode/shared_subquery_expr.yql
index a1bf46cf456..c3291ab32c8 100644
--- a/yql/essentials/tests/sql/suites/seq_mode/shared_subquery_expr.yql
+++ b/yql/essentials/tests/sql/suites/seq_mode/shared_subquery_expr.yql
@@ -1,4 +1,5 @@
 pragma SeqMode;
+pragma config.flags("DisableEarlyExpandSeq");
 $a = select 1;
 select * from $a;
 select * from $a;
diff --git a/yql/essentials/tests/sql/suites/seq_mode/simple1.yql b/yql/essentials/tests/sql/suites/seq_mode/simple1.yql
index eea968ad96f..b6446569260 100644
--- a/yql/essentials/tests/sql/suites/seq_mode/simple1.yql
+++ b/yql/essentials/tests/sql/suites/seq_mode/simple1.yql
@@ -1,3 +1,4 @@
 pragma SeqMode;
+pragma config.flags("DisableEarlyExpandSeq");
 select 1;
 
diff --git a/yql/essentials/tests/sql/suites/seq_mode/simple2.yql b/yql/essentials/tests/sql/suites/seq_mode/simple2.yql
index dbb53e3ecb6..5392a74d831 100644
--- a/yql/essentials/tests/sql/suites/seq_mode/simple2.yql
+++ b/yql/essentials/tests/sql/suites/seq_mode/simple2.yql
@@ -1,4 +1,5 @@
 pragma SeqMode;
+pragma config.flags("DisableEarlyExpandSeq");
 select 1;
 select 2;
 
diff --git a/yql/essentials/tests/sql/suites/seq_mode/subquery_shared_subquery.yql b/yql/essentials/tests/sql/suites/seq_mode/subquery_shared_subquery.yql
index f6064e86a50..bdcf0bf1a46 100644
--- a/yql/essentials/tests/sql/suites/seq_mode/subquery_shared_subquery.yql
+++ b/yql/essentials/tests/sql/suites/seq_mode/subquery_shared_subquery.yql
@@ -1,6 +1,7 @@
 pragma SeqMode;
+pragma config.flags("DisableEarlyExpandSeq");
 
-define subquery $a() as 
+define subquery $a() as
     $r = select 1 as x;
     select * from $r;
 end define;