Description:
Currently, there's no way to retrieve partition information except for using I_S.PARTITIONS table. However, it would be useful for many people if there's SHOW PARTITIONS command like below:
mysql> show partitions from t2;
+----------------+-------------+-----------------+-------------------+-------------+-----------------+-------------+------+
| Partition_Name | Part_Method | Part_Expression | Subpartition_Name | Subp_Method | Subp_Expression | Description | Rows |
+----------------+-------------+-----------------+-------------------+-------------+-----------------+-------------+------+
| p0 | HASH | a % 4 | NULL | NULL | NULL | NULL | 767 |
| p1 | HASH | a % 4 | NULL | NULL | NULL | NULL | 749 |
| p2 | HASH | a % 4 | NULL | NULL | NULL | NULL | 757 |
| p3 | HASH | a % 4 | NULL | NULL | NULL | NULL | 723 |
+----------------+-------------+-----------------+-------------------+-------------+-----------------+-------------+------+
4 rows in set (0.00 sec)
How to repeat:
n/a
Suggested fix:
see the patch