[MDEV-17683] sys_vars.delayed_insert_limit_func fails in buildbot with wrong result Created: 2018-11-12  Updated: 2019-09-03  Resolved: 2019-09-03

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.1, 10.2, 10.3
Fix Version/s: 10.2.27, 10.1.42, 10.3.18, 10.4.8

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/871

sys_vars.delayed_insert_limit_func       w3 [ fail ]
        Test ended at 2018-11-09 09:45:35
 
CURRENT_TEST: sys_vars.delayed_insert_limit_func
--- /usr/share/mysql-test/suite/sys_vars/r/delayed_insert_limit_func.result	2018-11-09 07:22:37.000000000 +0000
+++ /dev/shm/var/3/log/delayed_insert_limit_func.reject	2018-11-09 09:45:35.065221760 +0000
@@ -65,7 +65,7 @@
 The next result suffers from
 '# Bug#35386 insert delayed inserts 1 + limit rows instead of just limit rows'
 COUNT(*)
-21
+15
 connection default;
 Checking if the delayed insert continued afterwards
 SELECT COUNT(*) FROM t1;
 
mysqltest: Result content mismatch



 Comments   
Comment by Elena Stepanova [ 2019-02-04 ]

On 10.1:
http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-trusty-x86/builds/9146/steps/test/logs/stdio

sys_vars.delayed_insert_limit_func       w2 [ fail ]
        Test ended at 2019-01-17 06:49:47
 
CURRENT_TEST: sys_vars.delayed_insert_limit_func
--- /usr/local/mariadb-10.1.38-linux-i686/mysql-test/suite/sys_vars/r/delayed_insert_limit_func.result	2019-01-17 05:16:18.000000000 +0000
+++ /usr/local/mariadb-10.1.38-linux-i686/mysql-test/suite/sys_vars/r/delayed_insert_limit_func.reject	2019-01-17 06:49:47.310123908 +0000
@@ -64,7 +64,7 @@
 The next result suffers from
 '# Bug#35386 insert delayed inserts 1 + limit rows instead of just limit rows'
 COUNT(*)
-21
+12
 ** Connection default **
 Checking if the delayed insert continued afterwards
 SELECT COUNT(*) FROM t1;
 
mysqltest: Result content mismatch

Comment by Alexey Botchkov [ 2019-09-03 ]

https://github.com/MariaDB/server/commit/fe4eacde39fd4527f52624162eba7b636549ef31

Generated at Thu Feb 08 08:38:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.