--source include/have_partition.inc

--source include/have_innodb.inc

--source include/have_sequence.inc

CREATE TABLE t (pk INT PRIMARY KEY, a INT) ENGINE=InnoDB PARTITION BY HASH(pk);

INSERT INTO t SELECT seq, seq FROM seq_1_to_1000;

--connect (con1,localhost,root,,test)

--let $shutdown_timeout= 0

--send

ALTER TABLE t ADD KEY (a), ALGORITHM=INPLACE;

--connection default

--source include/restart_mysqld.inc

CHECK TABLE t;

# Cleanup

DROP TABLE t;

bug.t 'innodb'                           [ fail ]  Found warnings/errors in server log file!

        Test ended at 2023-06-17 22:19:56

line

2023-06-17 22:19:56 3 [ERROR] InnoDB indexes are inconsistent with what defined in .frm for table ./test/t#P#p0

2023-06-17 22:19:56 3 [ERROR] InnoDB: Table test/t#P#p0 contains 1 indexes inside InnoDB, which is different from the number of indexes 2 defined in the .frm file. See https://mariadb.com/kb/en/innodb-troubleshooting/

2023-06-17 22:19:56 3 [ERROR] InnoDB could not find key no 1 with name a from dict cache for table test/t#P#p0

2023-06-17 22:19:56 3 [ERROR] InnoDB: Table test/t#P#p0 contains 1 indexes inside InnoDB, which is different from the number of indexes 2 defined in the .frm file. See https://mariadb.com/kb/en/innodb-troubleshooting/

2023-06-17 22:19:56 3 [ERROR] InnoDB: Table test/t#P#p0 contains 1 indexes inside InnoDB, which is different from the number of indexes 2 defined in the .frm file. See https://mariadb.com/kb/en/innodb-troubleshooting/

2023-06-17 22:19:56 3 [ERROR] InnoDB could not find key no 1 with name a from dict cache for table test/t#P#p0

2023-06-17 22:19:56 3 [ERROR] InnoDB: Table test/t#P#p0 contains 1 indexes inside InnoDB, which is different from the number of indexes 2 defined in the .frm file. See https://mariadb.com/kb/en/innodb-troubleshooting/

^ Found warnings in /mnt8t/bld/10.6-asan/mysql-test/var/log/mysqld.1.err

ok

MTR's internal check of the test case 'bug.t' failed.

...

+#sql-alter-60b0a-5.par