Description:
NDBCLUSTER table doesn't use any INDEX while performing LIKE query:
How to repeat:
1. Create table:
CREATE TABLE `TEST` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`COL1` varchar(45) DEFAULT NULL,
`COL2` varchar(45) DEFAULT NULL,
`COL3` varchar(45) DEFAULT NULL,
`COL4` varchar(255) DEFAULT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ID_UNIQUE` (`ID`),
KEY `TIME` (`TIME`)
) ENGINE=ndbcluster AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
2. Insert ROW:
INSERT INTO TEST(COL1,COL2,COL3,COL4) VALUES (1,2,3,4);
3. Perform SELECT:
explain select ID from TEST where time like '2015%';
+----+-------------+-------+------+---------------+------+---------+------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+---------------+------+---------+------+------+-------------+
| 1 | SIMPLE | TEST | ALL | TIME | NULL | NULL | NULL | 2 | Using where |
+----+-------------+-------+------+---------------+------+---------+------+------+-------------+
possible_key is TIME but used key is NULL