diff options
author | Alexander Barkov <bar@mysql.com> | 2010-03-05 12:17:19 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mysql.com> | 2010-03-05 12:17:19 +0400 |
commit | 56dc1bd2e3bc1ecef0fd53048c47229ce4d503f5 (patch) | |
tree | e407eac5255599276b58eaa39c5b858cd7564b15 /mysql-test/r/ctype_utf8mb4_myisam.result | |
parent | 9f17a0018f5bfd9c5c6396e6b2f19def4a9b81c9 (diff) | |
download | mariadb-git-56dc1bd2e3bc1ecef0fd53048c47229ce4d503f5.tar.gz |
Fixing non-determenistic results.
Diffstat (limited to 'mysql-test/r/ctype_utf8mb4_myisam.result')
-rw-r--r-- | mysql-test/r/ctype_utf8mb4_myisam.result | 12 |
1 files changed, 6 insertions, 6 deletions
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'); |