Description
Hi,
We use some kind of migration manager to apply DDL migrations to YDB. And we've faced with an issue during the following migration:
PRAGMA TablePathPrefix = '/database/path/to/tables';
ALTER TABLE `my_table` ADD CHANGEFEED `my_feed` WITH (
FORMAT = 'JSON',
MODE = 'UPDATES',
RETENTION_PERIOD = Interval("P7D")
);
ALTER TOPIC `my_table/my_feed` ADD CONSUMER `my_consumer`;
ALTER TOPIC
migration fails due to TablePathPrefix
does not work for this command (only for ALTER TABLE
). As a result we created:
/database/path/to/tables/my_table
- table/database/path/to/tables/my_table/my_feed
- topic
But ALTER TOPIC
trying to find /database/my_table/my_feed
instead of /database/path/to/tables/my_table/my_feed
.
Is it possible to make PRAGMA TablePathPrefix
affect ALTER TOPIC
as well or add something like PRAGMA TopicPathPrefix
?