MariaDB [db]> show create table T\G

*************************** 1. row ***************************

       Table: imsmvi_fa_redacted

Create Table: CREATE TABLE `T` (

  `SMFDATETIME` datetime DEFAULT NULL,

...

  `SMFHOUR` int(11) DEFAULT NULL,

...

) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=0 ROW_FORMAT=PAGE TRANSACTIONAL=0;

MariaDB [db]> select count(*) from T;

+----------+

| count(*) |

+----------+

|  8594605 |

+----------+

1 row in set (0,050 sec)

MariaDB [db]> create index T_smfhour on T(smfhour); show warnings;

ERROR 1034 (HY000): Number of rows changed from 8594605 to 2296732

+-------+------+------------------------------------------------+

| Level | Code | Message                                        |

+-------+------+------------------------------------------------+

| Error | 1034 | Number of rows changed from 8594605 to 2296732 |

+-------+------+------------------------------------------------+

1 row in set (0,000 sec)

MariaDB [db]> select count(*) from T;

+----------+

| count(*) |

+----------+

|  2296732 |

+----------+

1 row in set (0,015 sec)

MariaDB [bad_redacted_db]> check table T;

+------------------------------------+-------+----------+--------------------------------------------------------------+

| Table                              | Op    | Msg_type | Msg_text                                                     |

+------------------------------------+-------+----------+--------------------------------------------------------------+

| db.T | check | error    | Record-count is not ok; found    8594605  Should be: 2296732 |

| db.T | check | error    | Key pointers and record positions doesn't match              |

| db.T | check | error    | Checksum for key:  1 doesn't match checksum for records      |

| db.T | check | error    | Corrupt                                                      |

+------------------------------------+-------+----------+--------------------------------------------------------------+

4 rows in set (1 min 33,710 sec)