+-------+---+---+
| s     | a | b |
+-------+---+---+
| m1 p2 | 2 | 1 |
| m1 p2 | 2 | 2 |
| m1 p2 | 3 | 1 |
| m1 p2 | 4 | 1 |
+-------+---+---+
+-----------------------+----------+
| s                     | COUNT(*) |
+-----------------------+----------+
| m1 WHERE a=3 (pruned) |        0 |
+-----------------------+----------+
+--------------+----------+
| s            | COUNT(*) |
+--------------+----------+
| m1 full scan |        5 |
+--------------+----------+
+----------+-------+----------+---------------------------------------------------------------------------+
| Table    | Op    | Msg_type | Msg_text                                                                  |
+----------+-------+----------+---------------------------------------------------------------------------+
| mtest.m1 | check | error    | Found a misplaced row                                                     |
| mtest.m1 | check | error    | Partition p2 returned error                                               |
| mtest.m1 | check | error    | Upgrade required. Please do "REPAIR TABLE `m1`" or dump/reload to fix it! |
+----------+-------+----------+---------------------------------------------------------------------------+
+-------+---+---+
| s     | a | b |
+-------+---+---+
| m2 p2 | 2 | 1 |
| m2 p2 | 2 | 2 |
+-------+---+---+
+---------+---+---+
| s       | a | b |
+---------+---+---+
| m2 pDEF | 3 | 1 |
| m2 pDEF | 4 | 1 |
+---------+---+---+
+------------------------+---+---+
| s                      | a | b |
+------------------------+---+---+
| m3 full repartition p2 | 2 | 1 |
| m3 full repartition p2 | 2 | 2 |
+------------------------+---+---+
+--------------------------+---+---+
| s                        | a | b |
+--------------------------+---+---+
| m3 full repartition pDEF | 3 | 1 |
| m3 full repartition pDEF | 4 | 1 |
+--------------------------+---+---+
