<feed xmlns='http://www.w3.org/2005/Atom'>
<title>ydb/yql/essentials/sql/v1/complete/analysis, branch oidc-1.2.5-dev</title>
<subtitle>Mirror of YDB github repos</subtitle>
<id>https://code.mastervirt.ru/ydb/atom?h=oidc-1.2.5-dev</id>
<link rel='self' href='https://code.mastervirt.ru/ydb/atom?h=oidc-1.2.5-dev'/>
<link rel='alternate' type='text/html' href='https://code.mastervirt.ru/ydb/'/>
<updated>2025-07-22T09:16:44Z</updated>
<entry>
<title>YQL-20221: Change binding replace range</title>
<updated>2025-07-22T09:16:44Z</updated>
<author>
<name>vitya-smirnov</name>
<email>vitya-smirnov@yandex-team.com</email>
</author>
<published>2025-07-22T08:57:55Z</published>
<link rel='alternate' type='text/html' href='https://code.mastervirt.ru/ydb/commit/?id=cf94d8a9ef2bd554213054a9cb6352a20a134a10'/>
<id>urn:sha1:cf94d8a9ef2bd554213054a9cb6352a20a134a10</id>
<content type='text'>
Symbol `$` was excluded from the `BindingName`
candidate content as `Replxx` interprets `$` as
a word break. The problem is that Monaco Editor
accounts `$` as a word part and filters out bindings.
This patch makes `$` a word part and adds replace
range to handle this properly at `Replxx`.
commit_hash:ca3959635a6c0e6688bcbe7622a9c2aab6c683eb
</content>
</entry>
<entry>
<title>YQL-19747: Complete table functions</title>
<updated>2025-07-10T13:49:06Z</updated>
<author>
<name>vitya-smirnov</name>
<email>vitya-smirnov@yandex-team.com</email>
</author>
<published>2025-07-10T13:18:41Z</published>
<link rel='alternate' type='text/html' href='https://code.mastervirt.ru/ydb/commit/?id=ab4a6f4beadc1b478f8c208d07226687821b5fc2'/>
<id>urn:sha1:ab4a6f4beadc1b478f8c208d07226687821b5fc2</id>
<content type='text'>
- 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
</content>
</entry>
<entry>
<title>YQL-19747: Fix query parameters parsing</title>
<updated>2025-07-09T12:53:30Z</updated>
<author>
<name>vitya-smirnov</name>
<email>vitya-smirnov@yandex-team.com</email>
</author>
<published>2025-07-09T12:39:02Z</published>
<link rel='alternate' type='text/html' href='https://code.mastervirt.ru/ydb/commit/?id=23a2115b6789bf11a74b5fa81a22028a509a6432'/>
<id>urn:sha1:23a2115b6789bf11a74b5fa81a22028a509a6432</id>
<content type='text'>
I missed that a query parameter key starts with
'$'.
commit_hash:1a24953b4f837da31db2201b9a9ffd0eef0c6b34
</content>
</entry>
<entry>
<title>YQL-17269: Support UNION/INTERSECT/EXCEPT combinations</title>
<updated>2025-07-09T11:38:43Z</updated>
<author>
<name>vitya-smirnov</name>
<email>vitya-smirnov@yandex-team.com</email>
</author>
<published>2025-07-09T11:16:01Z</published>
<link rel='alternate' type='text/html' href='https://code.mastervirt.ru/ydb/commit/?id=59c3167c208900bb714ff5cc477476e3ab14f4f0'/>
<id>urn:sha1:59c3167c208900bb714ff5cc477476e3ab14f4f0</id>
<content type='text'>
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
</content>
</entry>
<entry>
<title>YQL-19747: Fix binding precence at ID_QUOTED</title>
<updated>2025-07-09T08:57:27Z</updated>
<author>
<name>vitya-smirnov</name>
<email>vitya-smirnov@yandex-team.com</email>
</author>
<published>2025-07-09T08:33:21Z</published>
<link rel='alternate' type='text/html' href='https://code.mastervirt.ru/ydb/commit/?id=f767018cb425a62788b8e81932f2c2bc2a2e0953'/>
<id>urn:sha1:f767018cb425a62788b8e81932f2c2bc2a2e0953</id>
<content type='text'>
commit_hash:a497dfe8863a864913c1d6df4b28edbe7d8e4bba
</content>
</entry>
<entry>
<title>YQL-19747: Support LSP FilterText</title>
<updated>2025-07-03T12:02:48Z</updated>
<author>
<name>vitya-smirnov</name>
<email>vitya-smirnov@yandex-team.com</email>
</author>
<published>2025-07-03T11:40:24Z</published>
<link rel='alternate' type='text/html' href='https://code.mastervirt.ru/ydb/commit/?id=fdc3ed2f3a53f64b189d53b2cb81513916a78dc3'/>
<id>urn:sha1:fdc3ed2f3a53f64b189d53b2cb81513916a78dc3</id>
<content type='text'>
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
</content>
</entry>
<entry>
<title>YQL-19747: Support named subquery columns</title>
<updated>2025-07-03T09:20:50Z</updated>
<author>
<name>vitya-smirnov</name>
<email>vitya-smirnov@yandex-team.com</email>
</author>
<published>2025-07-03T08:45:10Z</published>
<link rel='alternate' type='text/html' href='https://code.mastervirt.ru/ydb/commit/?id=e8df0aab68da370650100281239a83aee119923c'/>
<id>urn:sha1:e8df0aab68da370650100281239a83aee119923c</id>
<content type='text'>
commit_hash:79ad481a8734a11e954d4a38e1218b17e116700c
</content>
</entry>
<entry>
<title>YQL-19747: Respect WITHOUT at schema synthesis</title>
<updated>2025-07-03T06:20:48Z</updated>
<author>
<name>vitya-smirnov</name>
<email>vitya-smirnov@yandex-team.com</email>
</author>
<published>2025-07-03T06:03:54Z</published>
<link rel='alternate' type='text/html' href='https://code.mastervirt.ru/ydb/commit/?id=ca30a190eaf6cca92ab870e5147dad2c2b19339b'/>
<id>urn:sha1:ca30a190eaf6cca92ab870e5147dad2c2b19339b</id>
<content type='text'>
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
</content>
</entry>
<entry>
<title>YQL-19747: Support JOIN ON, WHERE, GROUP/ORDER BY</title>
<updated>2025-07-02T10:34:13Z</updated>
<author>
<name>vitya-smirnov</name>
<email>vitya-smirnov@yandex-team.com</email>
</author>
<published>2025-07-02T10:22:58Z</published>
<link rel='alternate' type='text/html' href='https://code.mastervirt.ru/ydb/commit/?id=d92bd641fb97e9b3768d08a5b3a98d444d827b2c'/>
<id>urn:sha1:d92bd641fb97e9b3768d08a5b3a98d444d827b2c</id>
<content type='text'>
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
</content>
</entry>
<entry>
<title>YQL-19747: Refactor SQL completion engine</title>
<updated>2025-06-26T14:24:30Z</updated>
<author>
<name>vitya-smirnov</name>
<email>vitya-smirnov@yandex-team.com</email>
</author>
<published>2025-06-26T13:37:42Z</published>
<link rel='alternate' type='text/html' href='https://code.mastervirt.ru/ydb/commit/?id=633c9e434ac33037ba01b36a8f2937034903fe9f'/>
<id>urn:sha1:633c9e434ac33037ba01b36a8f2937034903fe9f</id>
<content type='text'>
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
</content>
</entry>
</feed>
