You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
DDL statements should respect target shard/kid that has been specified by the user in the mysql session.
Reproduction Steps
Create a keyspace with multiple shards and no vschema.
Try to perform an ALTER targeting specific kid:
use keyspace[kid]
alter statement ...
This alter is not respecting the target and it will try to apply it to all shards on this keyspace. Because there is no vschema, you will get an error like this:
Keyspace does not have exactly one shard
Expected behavior
This worked prior to 9.0. It is a weird use case, but at Slack we rely on this behavior.
Given that the target is being explicit about kid/shard that the DDL should be run, Vitess shouldn't error and apply the DDL.
The text was updated successfully, but these errors were encountered:
Overview of the Issue
DDL statements should respect target shard/kid that has been specified by the user in the mysql session.
Reproduction Steps
Expected behavior
The text was updated successfully, but these errors were encountered: