diff options
| author | vitya-smirnov <[email protected]> | 2025-07-13 10:57:03 +0300 |
|---|---|---|
| committer | vitya-smirnov <[email protected]> | 2025-07-13 11:13:18 +0300 |
| commit | 50fb38c344d3976f79badaef61cb8040ecdc404f (patch) | |
| tree | d802f56c25b770c8c42ca181aadc678957f08183 /yql/essentials/tests/sql/suites | |
| parent | d28a870061b49d7c985cd453eb01954173e4ffd0 (diff) | |
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
Diffstat (limited to 'yql/essentials/tests/sql/suites')
| -rw-r--r-- | yql/essentials/tests/sql/suites/select_op/select_op_precedence.sql | 12 |
1 files changed, 6 insertions, 6 deletions
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)); |