ydb/yql/essentials/sql/v1/complete/analysis/global, branch oidc-1.2.6.0-devMirror of YDB github reposhttps://code.mastervirt.ru/ydb/atom?h=oidc-1.2.6.0-dev2025-08-19T11:26:36ZYQL-19747: Fix some autocomplete issues2025-08-19T11:26:36Zvitya-smirnovvitya-smirnov@yandex-team.com2025-08-19T10:59:03Zurn:sha1:97d8c2c3ef7a3204232fd2b87573f309cf604902
- Collect only named node definitions
- Fix qualified column after WHERE
commit_hash:641977921329199e645c3ac45ae8053a5d0e8b13
YQL-19747: Infer table path from CONCAT and RANGE2025-08-19T10:26:01Zvitya-smirnovvitya-smirnov@yandex-team.com2025-08-19T10:09:59Zurn:sha1:6a26c68959783a009309949f61530030de259dc3
Table function `RANGE` is commonly used, so some
support for a table path inference is required. It
is done by doing ``` `prefix` || '/' || `min` ```.
commit_hash:4bec2a84a0ee8f6d97c92a46b4c4ebc7b41c4d7c
YQL-19747: Improve and fix completon engine2025-08-12T12:29:12Zvitya-smirnovvitya-smirnov@yandex-team.com2025-08-12T12:04:56Zurn:sha1:088fbdd4485f80a02567bbe84ed0e3f35337eb3d
Played with the autocomplete and found some issues:
https://nda.ya.ru/t/1F9ioYe37HVwo2.
- Supported `min`, `max` parameters of the `RANGE` table
function, respecting `prefix`.
- Supported cluster detecton at table function, e.g.
`SELECT * FROM plato.RANGE(Input1, Input2)`.
- Made column filter not to ignore a table alias.
- Supported keyword as identifier parsing.
- Supported `ID_QUOTED` as table alias.
commit_hash:9e9ff13373cd059e6a240ddff0ae18f599d790c0
YQL-19747: Fix an absent column after WHERE2025-08-08T14:33:39Zvitya-smirnovvitya-smirnov@yandex-team.com2025-08-08T13:57:59Zurn:sha1:b7df355898ae4eaf6d64fe31a7c4557271be12d4
Fixed an absence of column candidates at `SELECT * FROM t WHERE a#`.
The problem was with a `IsEnclosing` procedure, because here the cursor
is actually outside the `select_core` now there is a `_` symbol that
enlarge this rule text range.
commit_hash:0b493cb469333f9a37c923b06267ac026efeb2c9
YQL-19747: Partially concat and resolve symbols2025-08-04T09:47:13Zvitya-smirnovvitya-smirnov@yandex-team.com2025-08-04T09:34:52Zurn:sha1:2193f20a163ea765183f000e8d4e1902a96fed71
- Migrated GetId to a Partial Evaluation function.
- Centeralized named expressions collection.
- Centeralized query parameters resolution.
- Supported symbols resolution and concatenation.
- Migrated USE and Columns Syntesis on the evaluation.
commit_hash:fafedc4330bcd4a7ab607ae1d5f2691a2f5a60f2
YQL-19747: Complete table functions2025-07-10T13:49:06Zvitya-smirnovvitya-smirnov@yandex-team.com2025-07-10T13:18:41Zurn:sha1:ab4a6f4beadc1b478f8c208d07226687821b5fc2
- Added table functions completion.
- Also fixed a bug when USEd cluster
was not added to table context at table
function argument.
- Complete folder names at `prefix`
of `LIKE`, `RANGE`, etc.
commit_hash:26be383be728796e8431f906e2815acd77645ad4
YQL-19747: Fix query parameters parsing2025-07-09T12:53:30Zvitya-smirnovvitya-smirnov@yandex-team.com2025-07-09T12:39:02Zurn:sha1:23a2115b6789bf11a74b5fa81a22028a509a6432
I missed that a query parameter key starts with
'$'.
commit_hash:1a24953b4f837da31db2201b9a9ffd0eef0c6b34
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
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