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.
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 .`film_ actor` will not be altered. Specify --execute instead of --dry-run to alter the table. _film_actor_ new OK. .`_film_ actor_new` OK. .`film_ actor` was not altered. online- schema- change line 1904.
Starting a dry run. `sakila`
Creating new table...
Created new table sakila.
Altering new table...
Altered `sakila`
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`
Use of uninitialized value in exists at bin/pt-