Take a look at this:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | mysql> repair table a3; +---------+--------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------+--------+----------+----------+ | test.a3 | repair | status | OK | +---------+--------+----------+----------+ 1 row in set (0.10 sec) mysql> select * from a3 order by i; +------------+ | i | +------------+ | 2147483648 | | 11 | | 13 | | 14 | | 2147483647 | +------------+ 5 rows in set (0.00 sec) |
The sort order is obviously wrong while CHECK TABLE is not reporting any error
