Error formatting macro: code: java.lang.StackOverflowError
mysql> select * from t1 where a = 1 and c = 1 and d = 1 order by e desc;
ERROR 1031 (HY000): Table storage engine for 't1' doesn't have this option
mysql> explain extended select * from t1 where a = 1 and c = 1 and d = 1 order by e desc;
---
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
filtered |
Extra |
---
| 1 |
SIMPLE |
t1 |
ref |
PRIMARY,a |
a |
13 |
const,const,const |
10 |
100.00 |
Using where |
---
1 row in set, 1 warning (0.00 sec)
mysql> show warnings;
------
------
| Note |
1003 |
/* select#1 */ select `db1`.`t1`.`a` AS `a`,`db1`.`t1`.`b` AS `b`,`db1`.`t1`.`c` AS `c`,`db1`.`t1`.`d` AS `d`,`db1`.`t1`.`e` AS `e` from `db1`.`t1` where ((`db1`.`t1`.`d` = 1) and (`db1`.`t1`.`c` = 1) and (`db1`.`t1`.`a` = 1)) order by `db1`.`t1`.`e` desc |
------
1 row in set (0.01 sec)
mysql> show create table t1;
------
------
| t1 |
CREATE TABLE `t1` (
`a` int(11) NOT NULL DEFAULT '0',
`b` int(11) NOT NULL DEFAULT '0',
`c` int(11) NOT NULL DEFAULT '0',
`d` int(11) DEFAULT NULL,
`e` int(11) DEFAULT NULL,
PRIMARY KEY (`a`,`b`,`c`),
KEY `a` (`a`,`c`,`d`,`e`)
) ENGINE=LEVELDB DEFAULT CHARSET=latin1 |
------
1 row in set (0.00 sec)
[MDEV-4086]