summaryrefslogtreecommitdiffstats
path: root/yql/essentials/sql/v1/format/sql_format_ut.h
diff options
context:
space:
mode:
authorshumkovnd <[email protected]>2024-11-21 22:29:26 +0300
committershumkovnd <[email protected]>2024-11-21 22:51:14 +0300
commit74e7baa2f49d69b2f0385db557749750b6121a20 (patch)
tree6e7f4732613e61769184fa4aeaca53dc8913c761 /yql/essentials/sql/v1/format/sql_format_ut.h
parent56de0f56882d2401ca734478ff95d91878e5bdbd (diff)
Support ALTER SEQUENCE command
<https://github.com/ydb-platform/ydb/issues/11763> commit_hash:5611cbe2f0e09543749e9866c5db8d427649e754
Diffstat (limited to 'yql/essentials/sql/v1/format/sql_format_ut.h')
-rw-r--r--yql/essentials/sql/v1/format/sql_format_ut.h11
1 files changed, 11 insertions, 0 deletions
diff --git a/yql/essentials/sql/v1/format/sql_format_ut.h b/yql/essentials/sql/v1/format/sql_format_ut.h
index 021d57c8b13..fc919b38c43 100644
--- a/yql/essentials/sql/v1/format/sql_format_ut.h
+++ b/yql/essentials/sql/v1/format/sql_format_ut.h
@@ -115,6 +115,17 @@ Y_UNIT_TEST(AlterGroup) {
setup.Run(cases);
}
+Y_UNIT_TEST(AlterSequence) {
+ TCases cases = {
+ {"use plato;alter sequence sequence start with 10 increment 2 restart with 5;","USE plato;\n\nALTER SEQUENCE sequence START WITH 10 INCREMENT 2 RESTART WITH 5;\n"},
+ {"use plato;alter sequence if exists sequence increment 1000 start 100 restart;","USE plato;\n\nALTER SEQUENCE IF EXISTS sequence INCREMENT 1000 START 100 RESTART;\n"},
+ };
+
+ TSetup setup;
+ setup.Run(cases);
+}
+
+
Y_UNIT_TEST(Use) {
TCases cases = {
{"use user;","USE user;\n"},