Generate error for ALTER TABLE ADD ... AUTO_INCREMENT
Bug #1183081 reported by
Aleksey Sanin
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Galera |
Invalid
|
Undecided
|
Unassigned |
Bug Description
If table is not empty, then adding a column with AUTO_INCREMENT will not produce correct results on Galera:
ALTER TABLE foo ADD `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT
because each node will get its own IDs. Probably it is better to generate an error if user tries to run this query.
To post a comment you must log in.
Duplicate of lp:587170. But returning an error is a good point.