Generate error for ALTER TABLE ADD ... AUTO_INCREMENT

Bug #1183081 reported by Aleksey Sanin
6
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.

Revision history for this message
Alex Yurchenko (ayurchen) wrote :

Duplicate of lp:587170. But returning an error is a good point.

Changed in galera:
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.