Bug #71211 ARCHIVE engine does not guarantee UNIQUE and PRIMARY KEY constraints

Description:
You can break uniqueness in a table using Archive engine by just using optimize or repair commands.

How to repeat:
mysql> CREATE TABLE `c` ( `id` int(11) NOT NULL AUTO_INCREMENT, UNIQUE KEY (`id`) ) ENGINE=ARCHIVE;
Query OK, 0 rows affected (0.01 sec)

mysql> insert into c values (null);
Query OK, 1 row affected (0.00 sec)

mysql> insert into c values (null);
Query OK, 1 row affected (0.00 sec)

mysql> insert into c values (null);
Query OK, 1 row affected (0.00 sec)

mysql> select * from c;
+----+
| id |
+----+
|  1 |
|  2 |
|  3 |
+----+
3 rows in set (0.01 sec)
 
mysql> optimize table c;
+--------+----------+----------+----------+
| Table  | Op       | Msg_type | Msg_text |
+--------+----------+----------+----------+
| test.c | optimize | status   | OK       |
+--------+----------+----------+----------+
1 row in set (0.01 sec)

mysql> insert into c values (null);
Query OK, 1 row affected (0.00 sec)

mysql> select * from c;
+----+
| id |
+----+
|  1 |
|  2 |
|  3 |
|  1 |
+----+
4 rows in set (0.01 sec)

mysql> show indexes from c\G
*************************** 1. row ***************************
        Table: c
   Non_unique: 0
     Key_name: id
 Seq_in_index: 1
  Column_name: id
    Collation: NULL
  Cardinality: NULL
     Sub_part: NULL
       Packed: NULL
         Null: 
   Index_type: NONE
      Comment: 
Index_comment: 
1 row in set (0.00 sec)

Suggested fix:
Make the Archive engine SQL standards compliant.

Hello Przemyslaw,

Thank you for the bug report and test case.
Verified as described.

Thanks,
Umesh

also: http://bugs.mysql.com/bug.php?id=40216

Hey, is there anyone still using the ARCHIVE Storage Engine these days?

MySQL team - this engine code has been abandoned for over a decade. Wouldn't it be better to deprecate it completely and eliminate all the related source code burden? Unless you have a plan to update it and make the engine finally usable?

Would be good to convert this to a optional storage engine that isn't loaded by default.