Description:
unexpected and inconsistent behaviour:
mysql> create table t1(a int)engine=archive;
Query OK, 0 rows affected (0.16 sec)
mysql> insert into t1 values (1),(2),(3);
Query OK, 3 rows affected (0.11 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> checksum table t1;
+-------+----------+
| Table | Checksum |
+-------+----------+
| db.t1 | 0 |
+-------+----------+
1 row in set (7.84 sec)
mysql> show table status like 't1';
+------+---------+---------+------------+------
| Name | Engine | Version | Row_format | Rows
+------+---------+---------+------------+------
| t1 | ARCHIVE | 10 | Compressed | 3
+------+---------+---------+------------+------
1 row in set (0.28 sec)
mysql> checksum table t1;
+-------+-----------+
| Table | Checksum |
+-------+-----------+
| db.t1 | 251493421 |
+-------+-----------+
1 row in set (0.17 sec)
5.0.91 works as expected, and returns a checksum for both calls.
How to repeat:
drop table if exists t1;
create table t1(a int)engine=archive;
insert into t1 values (1),(2),(3);
checksum table t1 extended;
show table status like 't1';
checksum table t1 extended;
