A few days ago I was describing a common grievance when using
partitions.
When you care at a table, like the following
CREATE TABLE t1 ( d DATE )
PARTITION by range (to_days(d))
(
partition p001 VALUES LESS THAN (to_days('2001-01-01'))
, partition p002 VALUES LESS THAN (to_days('2001-02-01'))
, partition p003 VALUES LESS THAN (to_days('2001-03-01'))
);
Then you have the problem of finding out the original values.
SHOW CREATE TABLE doesn't help.
show create table t1\G
*************************** 1. row
***************************
Table: t1
Create Table: CREATE TABLE `t1` (
`d` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 /*!50100 PARTITION BY
RANGE (to_days(d)) (PARTITION p001 VALUES LESS THAN (730851)
ENGINE = MyISAM, PARTITION p002 VALUES LESS THAN (730882) ENGINE
= MyISAM, PARTITION p003 VALUES LESS …