Shulou(Shulou.com)06/01 Report--

To_days partition table bug

CREATE TABLE `aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa KEY `endTime` (`endTime`), KEY `aaaaaaaaaa_muti_ index` (`year`, `month`, `source`), KEY `aaaaaaaaaa_index_ source` (`source`), KEY `month_ index` (`month`), KEY `year_ index` (`year`) ENGINE=InnoDB AUTO_INCREMENT=1267666446 DEFAULT CHARSET=utf8 / *! 50100 PARTITION BY RANGE (to_days (startTime)) (PARTITION p20160405 VALUES LESS THAN (736425) ENGINE=InnoDB, PARTITION p20160620 VALUES LESS THAN (736501) ENGINE=InnoDB, PARTITION p20160706 VALUES LESS THAN (736517) ENGINE=InnoDB) * / execute the following sql Mysql can fix alter table aaaaaaaaaa add PARTITION (partition p_max values less than (maxvalue)) by crash select sid as sid,source as source,sum (valid) as valid,sum (error) as error from aaaaaaaaaa where startTime > = "2016-07-08 10:00:00"

In addition:

CREATE TABLE `aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa `sid`) ENGINE=InnoDB AUTO_INCREMENT=1267666446 DEFAULT CHARSET=utf8 / *! 50100 PARTITION BY RANGE (to_days (startTime)) (PARTITION p20160405 VALUES LESS THAN (736425) ENGINE=InnoDB, PARTITION p20160620 VALUES LESS THAN (736501) ENGINE=InnoDB, PARTITION p20160706 VALUES LESS THAN (736517) ENGINE=InnoDB) * / this will not cause the above problems, but if the starttime column is indexed There will be CREATE TABLE `aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa KEY `aaaaaaaaaa_index_ startTime` (`startTime`) ENGINE=InnoDB AUTO_INCREMENT=1267666446 DEFAULT CHARSET=utf8 / *! 50100 PARTITION BY RANGE (to_days (startTime)) (PARTITION p20160405 VALUES LESS THAN (736425) ENGINE=InnoDB, PARTITION p20160620 VALUES LESS THAN (736501) ENGINE=InnoDB, PARTITION p20160706 VALUES LESS THAN (736517) ENGINE=InnoDB) * / MOS did not find the relevant bug 5.1 5.6 5.5.24 if this problem is reproduced, please indicate the source QQ 273002188. Welcome to learn QQ group 236941212 oracle,mysql,PG to communicate with each other.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.