Bug #50435 sys_vars.delayed_insert_limit_func fails on Ubuntu x86_64 in debug mode
Submitted: 19 Jan 2010 9:51 Modified: 15 Oct 2012 14:36
Reporter: Alexander Nozdrin Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Tests: Server Severity:S7 (Test Cases)
Version:Celosia (M3) OS:Linux (Ubuntu x86_64)
Assigned to: Assigned Account CPU Architecture:Any
Tags: experimental, pb2, test failure

[19 Jan 2010 9:51] Alexander Nozdrin
Description:
sys_vars.delayed_insert_limit_func fails on Ubuntu x86_64 in debug mode:

sys_vars.delayed_insert_limit_func [ fail ]
        Test ended at 2010-01-18 18:34:48

CURRENT_TEST: sys_vars.delayed_insert_limit_func
--- /export/home2/pb2/test/sb_1-1195066-1263834911.28/mysql-5.5.99-m3-linux-x86_64-test/mysql-test/suite/sys_vars/r/delayed_insert_limit_func.result	2010-01-18 16:14:04.000000000 +0300
+++ /export/home2/pb2/test/sb_1-1195066-1263834911.28/mysql-5.5.99-m3-linux-x86_64-test/mysql-test/suite/sys_vars/r/delayed_insert_limit_func.reject	2010-01-18 20:34:48.000000000 +0300
@@ -108,7 +108,7 @@
 ** Connection con0 **
 Asynchronous "reap" result
 COUNT(*) = 22
-1
+0
 ** Connection default**
 Checking if the delayed insert gives the same result afterwards
 SELECT COUNT(*) = 22 FROM t1;

How to repeat:
See PB2/XRef2
[20 Jan 2010 12:43] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/97551

2963 Horst.Hunger	2010-01-20
      Patch for bug#50435: Allowed values in the 2nd select between 6 and 22 as they occur depending on the performance of the server and the sequence of insertes and select. The values must not be > 22, then the test must fail.
[20 Jan 2010 13:01] Matthias Leich
ok to push
[20 Jan 2010 13:15] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/97556

2963 Horst.Hunger	2010-01-20
      Patch for bug#50435: Allowed values in the 2nd select between 6 and 22 as they occur depending on the performance of the server and the sequence of insertes and select. The values must not be > 22, then the test must fail. Inserted a comment.
[25 Jan 2010 15:53] Alexander Nozdrin
Marking this bug experimental in next-mr.
Waiting for the merge from mysql-next-mr-bugfixing.