main.group_min_max 'innodb' w4 [ fail ]
|
Test ended at 2022-02-18 03:28:36
|
CURRENT_TEST: main.group_min_max
|
--- /usr/share/mysql/mysql-test/main/group_min_max.result 2022-02-17 04:50:11.000000000 +0000
|
+++ /tmp/tmp.VZrv9qJYiN/var/4/log/group_min_max.reject 2022-02-18 03:28:36.775672766 +0000
|
@@ -4059,7 +4059,7 @@
|
(2, TRUE, "yello"), (2, FALSE, "yello");
|
EXPLAIN SELECT DISTINCT owner_id FROM t1 WHERE foo = true GROUP BY owner_id HAVING (COUNT(*) = 1);
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t1 index NULL index_t1_on_owner_id_and_foo 7 NULL 5 Using where; Using index
|
+1 SIMPLE t1 index NULL index_t1_on_owner_id_and_foo 7 NULL 6 Using where; Using index
|
SELECT DISTINCT owner_id FROM t1 WHERE foo = true GROUP BY owner_id HAVING (COUNT(*) = 1);
|
owner_id
|
1
|
mysqltest: Result content mismatch
|