Comment 2 for bug 1259274

Version 2.2.19 still affected.

*************************** 1. row ***************************
       Table: x
Create Table: CREATE TABLE `x` (
  `id` int(11) NOT NULL,
  `s_id` varchar(10) NOT NULL,
  `s_date` date NOT NULL,
  `uuid` varchar(32) NOT NULL,
  PRIMARY KEY (`s_id`),
  UNIQUE KEY `uuid` (`uuid`),
  UNIQUE KEY `UPPERCASE_IDX` (`id`),
  KEY `idx_some_index` (`s_id`,`s_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

PTDEBUG=1 /data/perc/tmp/pt-online-schema-change --user=root --password=msandbox --host=127.0.01 --port=5522 --chunk-index='UPPERCASE_IDX' --no-check-alter --no-drop-old-table --no-drop-new-table --alter "drop primary key, add primary key(s_id), add index idx_some_index(s_id, s_date)" D=test,t=x --execute > debug.txt 2>&1

# NibbleIterator:5710 32714 One nibble: yes
# NibbleIterator:5741 32714 User wants to use index UPPERCASE_IDX
# NibbleIterator:5743 32714 Cannot use user index because it does not exist
# NibbleIterator:5769 32714 Auto-selecting best index
# TableParser:3308 32714 Indexes sorted best-first: PRIMARY, uppercase_idx, uuid
# NibbleIterator:5802 32714 Best index: PRIMARY