Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.6, 10.7(EOL), 10.8(EOL)
-
None
Description
I noticed that the test main.group_min_max sporadically fails with:
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
|
Examples:
- https://salsa.debian.org/mariadb-team/mariadb-server/-/jobs/2484602
- https://salsa.debian.org/illuusio/mariadb-server/-/jobs/2479900
Restarting the test passed, thus the issue is sporadic. Both of these happened on MariaDB 10.6.7 on Debian Sid.