[MDEV-32335] main.partition_innodb2 fails in buildbot with different EXPLAIN output Created: 2023-10-01  Updated: 2023-10-11  Resolved: 2023-10-03

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 11.0, 11.1, 11.2
Fix Version/s: 11.0.4, 11.1.3, 11.2.2

Type: Bug Priority: Blocker
Reporter: Elena Stepanova Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: None


 Description   

preview-11.3-preview b09e99ff7

main.partition_innodb2 'innodb'          w1 [ fail ]
        Test ended at 2023-09-17 08:51:10
 
CURRENT_TEST: main.partition_innodb2
--- /mnt/buildbot/build/mariadb-11.3.0/mysql-test/main/partition_innodb2.result	2023-09-17 04:23:21.000000000 -0400
+++ /mnt/buildbot/build/mariadb-11.3.0/mysql-test/main/partition_innodb2.reject	2023-09-17 08:51:09.429117589 -0400
@@ -18,7 +18,7 @@
 explain
 delete t1, t2 from t1, t2 where t1.a=t2.a;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	4	Using where
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	5	Using where
 1	SIMPLE	t2	ref	a	a	5	test.t1.a	1	
 delete t1, t2 from t1, t2 where t1.a=t2.a;
 drop table t1,t2;
 
mysqltest: Result content mismatch

Please start masking the row count in the test results if it's neither stable nor important.



 Comments   
Comment by Sergei Petrunia [ 2023-10-03 ]

The failure is in testcase for MDEV-30442, introduced in 11.0.

Generated at Thu Feb 08 10:30:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.