176
176
SET SESSION sql_mode='ONLY_FULL_GROUP_BY';
177
177
EXPLAIN EXTENDED SELECT 1 FROM t1
178
178
WHERE f1 > ALL( SELECT t.f1 FROM t1,t1 AS t );
179
ERROR 42000: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
182
Error 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
183
Note 1003 select 1 AS `1` from `test`.`t1` where <not>(<exists>(...))
179
id select_type table type possible_keys key key_len ref rows filtered Extra
180
1 PRIMARY NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
181
2 SUBQUERY t1 system NULL NULL NULL NULL 0 0.00 const row not found
182
2 SUBQUERY t system NULL NULL NULL NULL 0 0.00 const row not found
184
Note 1003 select 1 AS `1` from `test`.`t1` where 0
184
185
SET SESSION sql_mode=@old_sql_mode;
186
187
End of 5.0 tests.
251
252
id select_type table type possible_keys key key_len ref rows Extra
252
253
1 SIMPLE t1 ref c2,c2_2 c2 10 const,const 3 Using where
256
# Bug#56814 Explain + subselect + fulltext crashes server
258
CREATE TABLE t1(f1 VARCHAR(6) NOT NULL,
259
FULLTEXT KEY(f1),UNIQUE(f1));
260
INSERT INTO t1 VALUES ('test');
261
EXPLAIN SELECT 1 FROM t1
262
WHERE 1 > ALL((SELECT 1 FROM t1 JOIN t1 a ON (MATCH(t1.f1) AGAINST (""))
263
WHERE t1.f1 GROUP BY t1.f1));
264
id select_type table type possible_keys key key_len ref rows Extra
265
1 PRIMARY t1 system NULL NULL NULL NULL 1
266
2 SUBQUERY a system NULL NULL NULL NULL 1 Using filesort
267
2 SUBQUERY t1 fulltext f1 f1 0 1 Using where
269
'EXPLAIN SELECT 1 FROM t1
270
WHERE 1 > ALL((SELECT 1 FROM t1 RIGHT OUTER JOIN t1 a
271
ON (MATCH(t1.f1) AGAINST (""))
272
WHERE t1.f1 GROUP BY t1.f1))';
274
id select_type table type possible_keys key key_len ref rows Extra
275
1 PRIMARY t1 system NULL NULL NULL NULL 1
276
2 SUBQUERY a system NULL NULL NULL NULL 1 Using filesort
277
2 SUBQUERY t1 fulltext f1 f1 0 1 Using where
279
id select_type table type possible_keys key key_len ref rows Extra
280
1 PRIMARY t1 system NULL NULL NULL NULL 1
281
2 SUBQUERY a system NULL NULL NULL NULL 1 Using filesort
282
2 SUBQUERY t1 fulltext f1 f1 0 1 Using where
283
DEALLOCATE PREPARE stmt;
285
'EXPLAIN SELECT 1 FROM t1
286
WHERE 1 > ALL((SELECT 1 FROM t1 JOIN t1 a
287
ON (MATCH(t1.f1) AGAINST (""))
288
WHERE t1.f1 GROUP BY t1.f1))';
290
id select_type table type possible_keys key key_len ref rows Extra
291
1 PRIMARY t1 system NULL NULL NULL NULL 1
292
2 SUBQUERY a system NULL NULL NULL NULL 1 Using filesort
293
2 SUBQUERY t1 fulltext f1 f1 0 1 Using where
295
id select_type table type possible_keys key key_len ref rows Extra
296
1 PRIMARY t1 system NULL NULL NULL NULL 1
297
2 SUBQUERY a system NULL NULL NULL NULL 1 Using filesort
298
2 SUBQUERY t1 fulltext f1 f1 0 1 Using where
299
DEALLOCATE PREPARE stmt;
254
301
End of 5.1 tests.