|
CREATE TABLE t1 (pk INT PRIMARY KEY, a INT, b CHAR(1), KEY(a), KEY(a,b))
|
ENGINE=LevelDB;
|
INSERT INTO t1 VALUES (1,10,'x'), (2,20,'y');
|
|
EXPLAIN EXTENDED SELECT MAX(a) FROM t1 WHERE a < 100;
|
id select_type table type possible_keys key key_len ref rows filtered Extra
|
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No matching min/max row
|
Warnings:
|
Note 1003 /* select#1 */ select max(`test`.`t1`.`a`) AS `MAX(a)` from `test`.`t1` where (`test`.`t1`.`a` < 100)
|
|
SELECT MAX(a) FROM t1 WHERE a < 100;
|
MAX(a)
|
NULL
|
Test case:
CREATE TABLE t1 (pk INT PRIMARY KEY, a INT, b CHAR(1), KEY(a), KEY(a,b))
|
ENGINE=LevelDB;
|
INSERT INTO t1 VALUES (1,10,'x'), (2,20,'y');
|
SELECT MAX(a) FROM t1 WHERE a < 100;
|
revision-id: psergey@askmonty.org-20130124165745-nm4yaxrsu8e4o2ll
|
revno: 4511
|
branch-nick: mysql-5.6-leveldb
|
|