ydb/yql/essentials/sql, branch CLI_2.21.0 Mirror of YDB github repos https://code.mastervirt.ru/ydb/atom?h=CLI_2.21.0 2025-05-21T09:56:47Z Fix parsing INDEX GLOBAL (SYNC|ASYNC) 2025-05-21T09:56:47Z Vasily Gerasimov UgnineSirdis@ydb.tech 2025-05-21T09:38:34Z urn:sha1:a3559d6fde15102e1c1731e4bf7ee5cb0040a59d * Changelog entry Type: fix Component: yql Fix parsing unique index type. There was an error that, if not specified explicitly (SYNC or ASYNC), index type remained with the default value GLOBAL SYNC, despite that it was explicitly specified as UNIQUE in query. https://github.com/ydb-platform/ydb/issues/17885 --- Pull Request resolved: https://github.com/ytsaurus/ytsaurus/pull/1287 commit_hash:60de1b723fb1229f2197087fe21db67c72ccbd13 YQL-19747: Recover from unclosed ID_QUOTED 2025-05-20T10:23:38Z vityaman vityaman.dev@yandex.ru 2025-05-20T10:09:37Z urn:sha1:ae913bccb4fd8a8ba5f536c8afe622e2ad229fbc The simplest solution actually is an SQL injection. --- - Related to `YQL-19747` - Related to https://github.com/ydb-platform/ydb/issues/9056 - Related to https://github.com/ydb-platform/ydb/pull/18146 - Related to https://github.com/vityaman/ydb/issues/46 --- Pull Request resolved: https://github.com/ytsaurus/ytsaurus/pull/1283 commit_hash:7043e7cdd1e0d378926783d31cf5f8e055393aaa YQL-19747: Support USE statement 2025-05-20T10:07:06Z vityaman vityaman.dev@yandex.ru 2025-05-20T09:50:28Z urn:sha1:16630d4dfad772e0108e694f76f922e486cd6439 Introduce global analysis which will be extended with more ParseTree analysis later. --- - Related to `YQL-19747` - Related to https://github.com/vityaman/ydb/issues/40 --- Pull Request resolved: https://github.com/ytsaurus/ytsaurus/pull/1281 commit_hash:848fb3fdd6bc9612769c47d66198fca018ff465f YQL-19747: Fix unquoted object path completion 2025-05-19T14:51:48Z vityaman vityaman.dev@yandex.ru 2025-05-19T14:36:10Z urn:sha1:f16ede95953f8cdd44e3b762b175bd22e106bb5c On `SELECT * FROM pn` it completed to `SELECT * FROM ppnv1`, but expected ``` SELECT * FROM `pnv1` ```. --- - Related to `YQL-19747` - Related to https://github.com/ydb-platform/ydb/issues/9056 - Related to https://github.com/vityaman/ydb/issues/44 - Related to https://github.com/ydb-platform/ydb/pull/18146 --- Pull Request resolved: https://github.com/ytsaurus/ytsaurus/pull/1280 commit_hash:e937239fae7bf609bde6358b9b27c2b504c8ba32 YQL-19616: Fix TRegexLexer performance 2025-05-19T08:31:23Z vityaman vityaman.dev@yandex.ru 2025-05-19T08:17:12Z urn:sha1:50dbbb6a1e90cf9d1da40a92d563b02712b00b9e Fix `TRegexLexer` performance. Now it is just 2 times slower than a reference ANTLR implementation on Release mode, so merged regexes are 3 times better than scan&compare. ![image](https://github.com/user-attachments/assets/4e0cb27a-491d-4dbd-b10a-5725ffa6d902) --- - Related to `YQL-19616` - Related to https://github.com/ydb-platform/ydb/issues/15129 - Related to https://github.com/vityaman/ydb/issues/42 --- Pull Request resolved: https://github.com/ytsaurus/ytsaurus/pull/1278 commit_hash:1529f641172fea13f0d33fbfd06a4827c6efde01 Intermediate changes 2025-05-16T14:29:31Z robot-piglet robot-piglet@yandex-team.com 2025-05-16T14:18:58Z urn:sha1:0f357e6c327a00ca9d3286b62712fe84f1200c56 commit_hash:6b048925e9cf8eede1e184503d43f211b3be6dbd Intermediate changes 2025-05-16T12:42:03Z robot-piglet robot-piglet@yandex-team.com 2025-05-16T12:29:03Z urn:sha1:56a6cd70143215fe0a65817c8589064109d9650f commit_hash:2e70854d1aaae271baa81e098f791d9f4d54ddeb YQL-19747: Ignore type_id completions and table_key 2025-05-16T12:32:43Z vityaman vityaman.dev@yandex.ru 2025-05-16T12:20:12Z urn:sha1:31441fb3a8e27eb1c9f1125b55dd4a83d9310fc0 Fixes superfluous candidates (`OPTIONAL`, `CALLABLE`, ...) at `SELECT * FROM #`. --- - Related to `YQL-19747` - Related to https://github.com/ydb-platform/ydb/issues/9056 --- Pull Request resolved: https://github.com/ytsaurus/ytsaurus/pull/1273 commit_hash:d34d81ea86b8b6b5d339174be20d14d0371c3de6 YQL-19966 subqueries in views 2025-05-15T18:22:54Z vvvv vvvv@yandex-team.com 2025-05-15T17:55:36Z urn:sha1:b0dc0cab9b58d86e59d622f820b42cab95bcb07e commit_hash:d39880b60ceb7a5978a9ed1b8b95cfaf3c184373 YQL-19610: Split OrderedColumns into 2 pragmas 2025-05-13T01:41:22Z mrlolthe1st mrlolthe1st@yandex-team.com 2025-05-13T01:28:53Z urn:sha1:671f71f1b0a845d530dbcd0c7123eb67870e1f00 commit_hash:9780948e26ef2e689d26520b76fefa0794efdd9e