From 25a0bfb268609c662f8dea1ae7f640675c7a563d Mon Sep 17 00:00:00 2001 From: "konstantin@mysql.com" <> Date: Wed, 10 Dec 2003 01:08:10 +0300 Subject: bug #1335 tests followup: --disable_query_log was not a good idea, Serg says --- mysql-test/t/group_by.test | 4 ---- 1 file changed, 4 deletions(-) (limited to 'mysql-test/t/group_by.test') diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test index d28eeb27c15..58bb4b3e268 100644 --- a/mysql-test/t/group_by.test +++ b/mysql-test/t/group_by.test @@ -427,7 +427,6 @@ drop table t1; # Tests for bug #1355: 'Using filesort' is missing in EXPLAIN when ORDER BY # NULL is used. # ---disable_query_log CREATE TABLE t1 ( userid int(10) unsigned, score smallint(5) unsigned, @@ -438,9 +437,7 @@ INSERT INTO t1 VALUES (1,1),(2,2),(1,1),(3,3),(3,3),(3,3),(3,3),(3,3); # and then sort it with filesort (GROUP BY in MySQL # implies sorted order of results) SELECT userid,count(*) FROM t1 GROUP BY userid DESC; ---enable_query_log EXPLAIN SELECT userid,count(*) FROM t1 GROUP BY userid DESC; ---disable_query_log DROP TABLE t1; CREATE TABLE t1 ( i int(11) default NULL, @@ -448,6 +445,5 @@ CREATE TABLE t1 ( ); INSERT INTO t1 VALUES (1,2),(2,3),(4,5),(3,5),(1,5),(23,5); SELECT i, COUNT(DISTINCT(i)) FROM t1 GROUP BY j ORDER BY NULL; ---enable_query_log explain SELECT i, COUNT(DISTINCT(i)) FROM t1 GROUP BY j ORDER BY NULL; DROP TABLE t1; -- cgit v1.2.1