This is an upstream bug : http://bugs.mysql.com/bug.php?id=74779
**** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test; CREATE TABLE t1(a INT)ENGINE=InnoDB PARTITION BY list(a) (PARTITION p1 VALUES IN (1)); CREATE INDEX i1 ON t1(a); SELECT MAX(a)FROM t1 WHERE a>5;
This is an upstream bug : http:// bugs.mysql. com/bug. php?id= 74779
**** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(a INT)ENGINE=InnoDB PARTITION BY list(a) (PARTITION p1 VALUES IN (1));
CREATE INDEX i1 ON t1(a);
SELECT MAX(a)FROM t1 WHERE a>5;