percona_bug_999147 fails on debug builds

[Laurynas Biveinis]

innodb.percona_bug_999147 [ fail ] Found warnings/errors in server log file!
        Test ended at 2013-02-27 07:02:55
line
mysqld: /home/laurynas/percona/src/percona-server-5.6/Percona-Server/storage/innobase/handler/handler0alter.cc:368: virtual enum_alter_inplace_result ha_innobase::check_if_supported_inplace_alter(TABLE*, Alter_inplace_info*): Assertion `key_part->fieldnr < altered_table->s->fields' failed.
^ Found warnings in /home/laurynas/percona/src/percona-server-5.6/obj/mysql-test/var/log/mysqld.1.err
ok

This is introduced with https://code.launchpad.net/~sergei.glushchenko/percona-server/56-expand_fast_index_creation/+merge/139747 and is visible on all Jenkins builds: param build for the merge, staging testing build, all trunk builds since.

[Laurynas Biveinis (laurynas-biveinis)]

Exact steps I used to reproduce locally:
(ubuntu 12.10 x86_64, GCC 4.7.2)
in latest 5.6 trunk directory:
mkdir obj
cd obj
cmake ../Percona-Server/ -DWITH_DEBUG=ON -DWITH_EMBEDDED_SERVER=OFF
make -j4
cd mysql-test
./mysql-test-run --mem percona_bug_999147

[Sergei Glushchenko (sergei.glushchenko)]

As been discussed on IRC this bug is two different bugs.

First one is server crash with assertion failure

handler/handler0alter.cc:368: virtual enum_alter_inplace_result ha_innobase::check_if_supported_inplace_alter(TABLE*, Alter_inplace_info*): Assertion `key_part->fieldnr < altered_table->s->fields' failed.

to reproduce:

DROP TABLE IF EXISTS t1;
SET SESSION expand_fast_index_creation=ON;
CREATE TEMPORARY TABLE t1 (a INT, b INT, INDEX(a));
ALTER TABLE t1 ADD INDEX (b);

Second one is a warning which was been issued by explain_filename.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2900