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.
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; fast_index_ creation= ON;
SET SESSION expand_
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.