258
# Bug #11766300 59387: FAILING ASSERTION: CURSOR->POS_STATE == 1997660512 (BTR_PCUR_IS_POSITIONE
260
CREATE TABLE t1 (a INT) ENGINE=INNODB;
261
INSERT INTO t1 VALUES (0);
262
CREATE TABLE t2 (d BINARY(2), PRIMARY KEY (d(1)), UNIQUE KEY (d)) ENGINE=INNODB;
263
SELECT 1 FROM t1 WHERE NOT EXISTS
264
(SELECT 1 FROM t2 WHERE d = (SELECT d FROM t2 WHERE a >= 1) ORDER BY d);
267
EXPLAIN SELECT 1 FROM t1 WHERE NOT EXISTS
268
(SELECT 1 FROM t2 WHERE d = (SELECT d FROM t2 WHERE a >= 1) ORDER BY d);
269
id select_type table type possible_keys key key_len ref rows Extra
270
1 PRIMARY t1 ALL NULL NULL NULL NULL 1 Using where
271
2 DEPENDENT SUBQUERY t2 eq_ref PRIMARY,d d 2 func 1 Using where
272
3 DEPENDENT SUBQUERY t2 index NULL d 2 NULL 1 Using where; Using index
274
CREATE TABLE t2 (b INT, c INT, UNIQUE KEY (b), UNIQUE KEY (b, c )) ENGINE=INNODB;
275
INSERT INTO t2 VALUES (1, 1);
277
WHERE a != (SELECT 1 FROM t2 WHERE a <=> b OR a > '' AND 6 = 7 ORDER BY b, c);
281
# Bug #13639204 64111: CRASH ON SELECT SUBQUERY WITH NON UNIQUE
287
INSERT INTO t1 (id) VALUES (11);
292
KEY t1_id_position (t1_id,position)
295
(SELECT position FROM t2
296
WHERE t2.t1_id = t1.id
297
ORDER BY t2.t1_id , t2.position
302
id select_type table type possible_keys key key_len ref rows Extra
303
1 PRIMARY t1 ALL NULL NULL NULL NULL 1
304
2 DEPENDENT SUBQUERY t2 ref t1_id,t1_id_position t1_id_position 5 test.t1.id 1 Using where
306
(SELECT position FROM t2
307
WHERE t2.t1_id = t1.id
308
ORDER BY t2.t1_id , t2.position