From 56dc1bd2e3bc1ecef0fd53048c47229ce4d503f5 Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Fri, 5 Mar 2010 12:17:19 +0400 Subject: Fixing non-determenistic results. --- mysql-test/r/ctype_utf8mb4_myisam.result | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'mysql-test/r/ctype_utf8mb4_myisam.result') diff --git a/mysql-test/r/ctype_utf8mb4_myisam.result b/mysql-test/r/ctype_utf8mb4_myisam.result index ca5683bfd65..03f7358435d 100644 --- a/mysql-test/r/ctype_utf8mb4_myisam.result +++ b/mysql-test/r/ctype_utf8mb4_myisam.result @@ -1526,15 +1526,15 @@ insert into t1 values (unhex('65')), (unhex('C3A9')), (unhex('65')); explain select distinct a from t1; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 3 Using temporary -select distinct a from t1; -a -e +SELECT COUNT(*) FROM (SELECT DISTINCT a FROM t1) AS t2; +COUNT(*) +1 explain select a from t1 group by a; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 3 Using temporary; Using filesort -select a from t1 group by a; -a -e +SELECT COUNT(*) FROM (SELECT a FROM t1 GROUP BY a) AS t2; +COUNT(*) +1 drop table t1; create table t1(a char(10)) default charset utf8mb4 engine MyISAM; insert into t1 values ('123'), ('456'); -- cgit v1.2.1