Bogus error message "Found wrong key definition ..; Please do "ALTER TABLE .. FORCE" to fix it!"

INSTALL SONAME 'ha_archive';

CREATE TABLE t (a DECIMAL(20) NOT NULL) ENGINE=Archive;

--error ER_CANT_CREATE_TABLE

ALTER TABLE t ADD INDEX(a);

SHOW WARNINGS;

# Cleanup

DROP TABLE t;

UNINSTALL SONAME 'ha_archive';

ALTER TABLE t ADD INDEX(a);

ERROR HY000: Can't create table `test`.`t` (errno: 140 "Wrong create options")

SHOW WARNINGS;

Level	Code	Message

Note	1071	Specified key was too long; max key length is 8 bytes

Warning	1194	Found wrong key definition in t; Please do "ALTER TABLE 't' FORCE" to fix it!

Warning	1194	Found wrong key definition in t; Please do "ALTER TABLE 't' FORCE" to fix it!

Error	1005	Can't create table `test`.`t` (errno: 140 "Wrong create options")

Warning	1030	Got error 140 "Wrong create options" from storage engine ARCHIVE

DROP TABLE t;

UNINSTALL SONAME 'ha_archive';

bug.x                               [ fail ]  Found warnings/errors in server log file!

        Test ended at 2023-12-04 22:06:46

line

2023-12-04 22:06:46 4 [ERROR] Found wrong key definition in t; Please do "ALTER TABLE 't' FORCE " to fix it!

2023-12-04 22:06:46 4 [ERROR] Found wrong key definition in t; Please do "ALTER TABLE 't' FORCE " to fix it!

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