Re: After partition, query returns wrong result.

[yansheng lin]

This is the CREATE TABLE statement.

CREATE TABLE `books` (
`department_id` int(10) unsigned NOT NULL default '0',
`book_id` int(10) unsigned NOT NULL default '0',
`session_count` decimal(38,0) NOT NULL default '0',
`log_hour` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`department_id`,`book_id`,`log_hour`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PARTITION BY RANGE (YEAR(log_hour)*100+MONTH(log_hour)) (PARTITION p1 VALUES LESS THAN (200605) ENGINE = MyISAM, PARTITION p2 VALUES LESS THAN (200606) ENGINE = MyISAM, PARTITION p3 VALUES LESS THAN (200607) ENGINE = MyISAM, PARTITION p4 VALUES LESS THAN (200608) ENGINE = MyISAM, PARTITION p5 VALUES LESS THAN (200609) ENGINE = MyISAM, PARTITION p6 VALUES LESS THAN (200610) ENGINE = MyISAM, PARTITION p7 VALUES LESS THAN (200611) ENGINE = MyISAM, PARTITION p8 VALUES LESS THAN (200612) ENGINE = MyISAM, PARTITION p9 VALUES LESS THAN (200701) ENGINE = MyISAM, PARTITION p10 VALUES LESS THAN (200702) ENGINE = MyISAM, PARTITION p11 VALUES LESS THAN (200703) ENGINE = MyISAM, PARTITION p12 VALUES LESS THAN (200704) ENGINE = MyISAM, PARTITION p13 VALUES LESS THAN (200705) ENGINE = MyISAM, PARTITION p14 VALUES LESS THAN MAXVALUE ENGINE = MyISAM);