ydb/yql/essentials/tests/sql/suites/select_op, branch mainMirror of YDB github reposhttps://code.mastervirt.ru/ydb/atom?h=main2025-10-01T18:25:50ZYQL-20307: Support inline subqueries2025-10-01T18:25:50Zvitya-smirnovvitya-smirnov@yandex-team.com2025-10-01T17:51:41Zurn:sha1:f3f7b33a285e94cb3e27aaa4d9b23b543ece4106
- Alter grammar to support inline subqueries.
- Support inline subqueries in `sql/v1` (translator).
- Introduce `sql/v1/proto_ast/parse_tree.h` for reusable parse tree predicates.
- Support inline subqueries in `sql/v1/format`.
- Support inline subqueries in `sql/v1/complete`.
- Add some SQL-tests.
- Pass all tests.
commit_hash:075b2240778d071e1c7542f912d3cc83019ef849
Intermediate changes2025-08-13T16:26:32Zrobot-pigletrobot-piglet@yandex-team.com2025-08-13T16:14:34Zurn:sha1:aae2cfe567a3498ec7c2d50a736c816fe57c4a9f
commit_hash:e6cca97ec9c9627f1ba82a11abf454518fc90972
YQL-17269: Fix UNION/EXCEPT/INTERSECT precedence2025-07-13T08:13:18Zvitya-smirnovvitya-smirnov@yandex-team.com2025-07-13T07:57:03Zurn:sha1:50fb38c344d3976f79badaef61cb8040ecdc404f
There was a mistake, because actually EXCEPT
has the same precedence as UNION. INTERSECT has
higher precedence than.
commit_hash:20375ef498861c6704571161fa3c4eebf54e895c
YQL-17269: Support UNION/INTERSECT/EXCEPT combinations2025-07-09T11:38:43Zvitya-smirnovvitya-smirnov@yandex-team.com2025-07-09T11:16:01Zurn:sha1:59c3167c208900bb714ff5cc477476e3ab14f4f0
Introduce `UNION` and `INTERSECT/EXCEPT` grammar rules
for precedence. Rewrote `Build` procedure into `BuildStmt`,
`BuildUnion`, `BuildIntersection`. Added tests, modify format.
It took a lot of time trying to adapt the existing `Build` procedure.
The I noticed that the logic for `union` and `intersection` is
different, since `union` groups arguments into bundles, but
`intersection` is a strictly binary operation.
commit_hash:70008ae3c2603364b6dfbeeb189fdc7f5237433d