Comment 1 for bug 1010232

Revision history for this message
Baron Schwartz (baron-xaprb) wrote :

I've found additional problems with this when I specify a prefix that's larger than the number of columns in the index, in pt-osc.

$ bin/pt-online-schema-change --alter='engine=innodb' h=127.1,P=3306,D=sakila,t=film_actor,u=root --lock-wait-timeout=50 --dry-run --chunk-index PRIMARY:3
Starting a dry run. `sakila`.`film_actor` will not be altered. Specify --execute instead of --dry-run to alter the table.
Creating new table...
Created new table sakila._film_actor_new OK.
Altering new table...
Altered `sakila`.`_film_actor_new` OK.
Not creating triggers because this is a dry run.
Not dropping triggers because this is a dry run.
Dropping new table...
Dropped new table OK.
Dry run complete. `sakila`.`film_actor` was not altered.
Use of uninitialized value in exists at bin/pt-online-schema-change line 1904.