YQL-17269: Fix UNION/EXCEPT/INTERSECT precedence

There was a mistake, because actually EXCEPT
has the same precedence as UNION. INTERSECT has
higher precedence than.
commit_hash:20375ef498861c6704571161fa3c4eebf54e895c

4 files changed, 23 insertions, 23 deletions

diff --git a/yql/essentials/tests/sql/minirun/part4/canondata/result.json b/yql/essentials/tests/sql/minirun/part4/canondata/result.json
index 28b0265e7f5..e6d2cfd6553 100644
--- a/yql/essentials/tests/sql/minirun/part4/canondata/result.json
+++ b/yql/essentials/tests/sql/minirun/part4/canondata/result.json
@@ -1613,16 +1613,16 @@
     ],
     "test.test[select_op-select_op_precedence-default.txt-Debug]": [
         {
-            "checksum": "d988a916cc8cf62b2b0a209dac05e6ad",
-            "size": 2449,
-            "uri": "https://{canondata_backend}/1937424/ee95b3be0f5d76ab6152d1ca5aedc6f278ad320b/resource.tar.gz#test.test_select_op-select_op_precedence-default.txt-Debug_/opt.yql"
+            "checksum": "3cc5644e63d6d4d4601132f97c177a71",
+            "size": 2350,
+            "uri": "https://{canondata_backend}/1871182/4957464f17f4b05ffc05eeebd894c6e979082da5/resource.tar.gz#test.test_select_op-select_op_precedence-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[select_op-select_op_precedence-default.txt-Results]": [
         {
-            "checksum": "355b6ce9dc8117b59c91a73b5a309c1e",
-            "size": 2428,
-            "uri": "https://{canondata_backend}/1937424/ee95b3be0f5d76ab6152d1ca5aedc6f278ad320b/resource.tar.gz#test.test_select_op-select_op_precedence-default.txt-Results_/results.txt"
+            "checksum": "c0efe7c81a642f898ef8a9edaa9744eb",
+            "size": 2355,
+            "uri": "https://{canondata_backend}/1871182/4957464f17f4b05ffc05eeebd894c6e979082da5/resource.tar.gz#test.test_select_op-select_op_precedence-default.txt-Results_/results.txt"
         }
     ],
     "test.test[udf-same_udf_modules--Debug]": [
diff --git a/yql/essentials/tests/sql/minirun/part9/canondata/result.json b/yql/essentials/tests/sql/minirun/part9/canondata/result.json
index 5748430323b..935388a50fc 100644
--- a/yql/essentials/tests/sql/minirun/part9/canondata/result.json
+++ b/yql/essentials/tests/sql/minirun/part9/canondata/result.json
@@ -1428,16 +1428,16 @@
     ],
     "test.test[select_op-select_op_order_by-default.txt-Debug]": [
         {
-            "checksum": "91caa30e8db750c1ec76d151fca78754",
-            "size": 1330,
-            "uri": "https://{canondata_backend}/1937429/9e4129b6ff2ea8916fb065ef6e1c352f09062635/resource.tar.gz#test.test_select_op-select_op_order_by-default.txt-Debug_/opt.yql"
+            "checksum": "a4d6a392dd1a49d7f8ca0ff624c50d84",
+            "size": 1362,
+            "uri": "https://{canondata_backend}/1937429/18d53b6e51c2d67a4139b1541925383ccf907eb1/resource.tar.gz#test.test_select_op-select_op_order_by-default.txt-Debug_/opt.yql"
         }
     ],
     "test.test[select_op-select_op_order_by-default.txt-Results]": [
         {
-            "checksum": "d60baea9173f30a2120442ad48fbe6f1",
-            "size": 1608,
-            "uri": "https://{canondata_backend}/995452/5090a24ed2603cf2d46948bbefc60f465212e8eb/resource.tar.gz#test.test_select_op-select_op_order_by-default.txt-Results_/results.txt"
+            "checksum": "39d3126f3afa785bad90779dcbef0d66",
+            "size": 1462,
+            "uri": "https://{canondata_backend}/1937429/18d53b6e51c2d67a4139b1541925383ccf907eb1/resource.tar.gz#test.test_select_op-select_op_order_by-default.txt-Results_/results.txt"
         }
     ],
     "test.test[udf-udaf_default-default.txt-Debug]": [
diff --git a/yql/essentials/tests/sql/sql2yql/canondata/result.json b/yql/essentials/tests/sql/sql2yql/canondata/result.json
index 3181fd5b022..069f12459ea 100644
--- a/yql/essentials/tests/sql/sql2yql/canondata/result.json
+++ b/yql/essentials/tests/sql/sql2yql/canondata/result.json
@@ -7428,16 +7428,16 @@
     ],
     "test_sql2yql.test[select_op-select_op_order_by]": [
         {
-            "checksum": "c29c29e19e0a2dc2ec0b18e5f514d257",
+            "checksum": "5bb387570099b20bc348a61fb9aca5cf",
             "size": 5911,
-            "uri": "https://{canondata_backend}/1600758/b6a6fb350f1fdfbb2cdd5ef84cd0c97f27aa4e1a/resource.tar.gz#test_sql2yql.test_select_op-select_op_order_by_/sql.yql"
+            "uri": "https://{canondata_backend}/1871182/dae39f0cfd95af470ed2892346cc8716e27e027e/resource.tar.gz#test_sql2yql.test_select_op-select_op_order_by_/sql.yql"
         }
     ],
     "test_sql2yql.test[select_op-select_op_precedence]": [
         {
-            "checksum": "1aa020ec98a803bed27d3e9d69bd1cc8",
-            "size": 7832,
-            "uri": "https://{canondata_backend}/1937424/ff4229d081f7de79cc74b919a7e5f6c33b478b7f/resource.tar.gz#test_sql2yql.test_select_op-select_op_precedence_/sql.yql"
+            "checksum": "97a131fbcb318306e7a59d28174a3861",
+            "size": 7840,
+            "uri": "https://{canondata_backend}/1871182/dae39f0cfd95af470ed2892346cc8716e27e027e/resource.tar.gz#test_sql2yql.test_select_op-select_op_precedence_/sql.yql"
         }
     ],
     "test_sql2yql.test[seq_mode-shared_named_expr]": [
diff --git a/yql/essentials/tests/sql/suites/select_op/select_op_precedence.sql b/yql/essentials/tests/sql/suites/select_op/select_op_precedence.sql
index f8f08006e26..7212b21855c 100644
--- a/yql/essentials/tests/sql/suites/select_op/select_op_precedence.sql
+++ b/yql/essentials/tests/sql/suites/select_op/select_op_precedence.sql
@@ -5,11 +5,11 @@ UNION
     (SELECT * FROM (VALUES (3)) AS t (x));
 
 
-    (SELECT * FROM (VALUES (3)) AS t (x))
+(SELECT * FROM (VALUES (3)) AS t (x))
 UNION
-    (SELECT * FROM (VALUES (2)) AS t (x))
-    EXCEPT
-    (SELECT * FROM (VALUES (3)) AS t (x));
+(SELECT * FROM (VALUES (2)) AS t (x))
+EXCEPT
+(SELECT * FROM (VALUES (3)) AS t (x));
 
 
     (SELECT * FROM (VALUES (1)) AS t (x))
@@ -17,9 +17,9 @@ UNION
     (SELECT * FROM (VALUES (2)) AS t (x))
     INTERSECT
     (SELECT * FROM (VALUES (2), (3)) AS t (x))
-    EXCEPT
+EXCEPT
     (SELECT * FROM (VALUES (3)) AS t (x))
 UNION
     (SELECT * FROM (VALUES (4), (3)) AS t (x))
-    EXCEPT
+EXCEPT
     (SELECT * FROM (VALUES (4)) AS t (x));