MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:Horst.Hunger Date:January 20 2010 1:15pm
Subject:bzr commit into mysql-5.5-next-mr branch (horst.hunger:2963) Bug#50435
View as plain text  
#At file:///home/horst/bzr/mysql-50435/ based on revid:alik@ibmvm-20100118120111-73dulkgc893it4r9

 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.

    modified:
      mysql-test/suite/sys_vars/r/delayed_insert_limit_func.result
      mysql-test/suite/sys_vars/t/delayed_insert_limit_func.test
=== modified file 'mysql-test/suite/sys_vars/r/delayed_insert_limit_func.result'
--- a/mysql-test/suite/sys_vars/r/delayed_insert_limit_func.result	2009-03-20 17:11:22 +0000
+++ b/mysql-test/suite/sys_vars/r/delayed_insert_limit_func.result	2010-01-20 13:15:43 +0000
@@ -100,19 +100,19 @@ INSERT DELAYED INTO t1 VALUES('21');
 INSERT DELAYED INTO t1 VALUES('22');|
 ** Connection con0 **
 Asynchronous execute
-SELECT COUNT(*) = 22 FROM t1;
+SELECT COUNT(*) BETWEEN 6 AND 22 FROM t1;
 ** Connection default **
 ** Wait till con0 is blocked **
 UNLOCK TABLES;
 ** Connection con1 **
 ** Connection con0 **
 Asynchronous "reap" result
-COUNT(*) = 22
+COUNT(*) BETWEEN 6 AND 22
 1
 ** Connection default**
 Checking if the delayed insert gives the same result afterwards
-SELECT COUNT(*) = 22 FROM t1;
-COUNT(*) = 22
+SELECT COUNT(*) BETWEEN 6 AND 22 FROM t1;
+COUNT(*) BETWEEN 6 AND 22
 1
 ** Connection default**
 DROP TABLE t1;

=== modified file 'mysql-test/suite/sys_vars/t/delayed_insert_limit_func.test'
--- a/mysql-test/suite/sys_vars/t/delayed_insert_limit_func.test	2009-12-31 13:05:33 +0000
+++ b/mysql-test/suite/sys_vars/t/delayed_insert_limit_func.test	2010-01-20 13:15:43 +0000
@@ -205,7 +205,9 @@ let $wait_condition=
    WHERE variable_name like 'Not_flushed_delayed_rows';
 --source include/wait_condition.inc
 --echo Asynchronous execute
-let $my_select= SELECT COUNT(*) = 22 FROM t1;
+# Due to performance and server behaveiour the test observes values between 6 and 22.
+# In any case the value must not be outside of that range.
+let $my_select= SELECT COUNT(*) BETWEEN 6 AND 22 FROM t1;
 send;
 eval $my_select;
 


Attachment: [text/bzr-bundle] bzr/horst.hunger@sun.com-20100120131543-wqy5oe3szjb42b2v.bundle
Thread
bzr commit into mysql-5.5-next-mr branch (horst.hunger:2963) Bug#50435Horst.Hunger20 Jan