ydb/yql/essentials/sql/v1/complete/analysis/global/column.cpp, branch oidc-1.2.5-devMirror of YDB github reposhttps://code.mastervirt.ru/ydb/atom?h=oidc-1.2.5-dev2025-07-09T11:38:43ZYQL-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
YQL-19747: Support LSP FilterText2025-07-03T12:02:48Zvitya-smirnovvitya-smirnov@yandex-team.com2025-07-03T11:40:24Zurn:sha1:fdc3ed2f3a53f64b189d53b2cb81513916a78dc3
LSP protocol has a property
```
/**
* A string that should be used when filtering a set of
* completion items. When omitted the label is used as the
* filter text for this item.
*/
filterText?: string;
```
It is useful, e.g. when we prepend some punctuation
at a candidate content, but still want to filter by
prefix, ignoring that punctuation.
Related to https://nda.ya.ru/t/KCkzjhXS7G3Epg.
commit_hash:01f258218d312eef764350bd4d78da15acb8c9ea
YQL-19747: Support named subquery columns2025-07-03T09:20:50Zvitya-smirnovvitya-smirnov@yandex-team.com2025-07-03T08:45:10Zurn:sha1:e8df0aab68da370650100281239a83aee119923c
commit_hash:79ad481a8734a11e954d4a38e1218b17e116700c
YQL-19747: Respect WITHOUT at schema synthesis2025-07-03T06:20:48Zvitya-smirnovvitya-smirnov@yandex-team.com2025-07-03T06:03:54Zurn:sha1:ca30a190eaf6cca92ab870e5147dad2c2b19339b
Also fixed a bug when the same table used with
and without an alias produced duplicated column
names. This is incorrect at translator, but anyway
we need to handle it gracefully. Also refactored
some utility methods like context union.
commit_hash:45a12675e865bb9d929e5e5178e16239a763d1f5
YQL-19747: Support JOIN ON, WHERE, GROUP/ORDER BY2025-07-02T10:34:13Zvitya-smirnovvitya-smirnov@yandex-team.com2025-07-02T10:22:58Zurn:sha1:d92bd641fb97e9b3768d08a5b3a98d444d827b2c
Before this patch we completed columns only at
SELECT projection. Now we complete it at these
constructions. Also it respects visibility rules.
commit_hash:aa1e6d4900e9b032801ddbf3bcd347750c2939b1
YQL-19747: Refactor SQL completion engine2025-06-26T14:24:30Zvitya-smirnovvitya-smirnov@yandex-team.com2025-06-26T13:37:42Zurn:sha1:633c9e434ac33037ba01b36a8f2937034903fe9f
Some refactorings to compact the code:
- YQL-19747: Pass TParsedInput to visitor
- YQL-19747: Add TParsedInput
- YQL-19747: Cosmetics
- YQL-19747: Refactor configuration
- YQL-19747: Refactor name to candidate mapping
commit_hash:44dfe7dc7bcc627ef9c20696077f2d962a3014f6
YQL-19747: Support qualified asterisk2025-06-25T15:20:11Zvitya-smirnovvitya-smirnov@yandex-team.com2025-06-25T15:07:35Zurn:sha1:84acd92b6733ab01d0c4c2c2d1363bb8bc66ccd3
Support `SELECT x.* FROM t AS x`.
commit_hash:64693f65281f385d6c0d3541fb2874b0153aa88c
YQL-19747: Synthesise subquery columns2025-06-24T13:06:46Zvitya-smirnovvitya-smirnov@yandex-team.com2025-06-24T12:50:39Zurn:sha1:573dadf304e5729bdad2dc02fd7c4ad2cb7a0524
commit_hash:40a2de243a67135e44505619fb766954ba24e2e8
YQL-19747: Complete columns from JOIN2025-06-23T14:48:51Zvitya-smirnovvitya-smirnov@yandex-team.com2025-06-23T14:15:31Zurn:sha1:b4ef2d519178ae0e2cd3c5d30cbd5010c72014d2
Collect tables with aliases during global
analysis and send a multiple requests
to a schema provider.
commit_hash:51cbc40cee6cda09d5bfe256a0425e7c809c04f5
YQL-19747: Support table aliases2025-06-18T14:40:32Zvitya-smirnovvitya-smirnov@yandex-team.com2025-06-18T14:03:59Zurn:sha1:0ac6c9eac8c5c9d71141af3c89f7cfc1b66a279e
commit_hash:6d67ec1fa5023083debd89aaa99950019ca37c90