From: Hiromichi Watari
Date: June 15 2011 3:08pm
Subject: Regression test returning different result each time it's run
List-Archive: http://lists.mysql.com/internals/38338
Message-Id: <585819.60238.qm@web121514.mail.ne1.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Hi,

I'm running a regression test (/mysql-test/t/select.test) on 5.5 server (LaunchPad rev 3487) but each time I run the test I get different number of rows in explain select statements.
Is this normal behavior ?  Or am I missing something ?

Thanks,
Hiromichi

p.s. I start up the server first then issue the following command,

[hwatari@desktop-intel mysql-test]$ sudo ./mysql-test-run.pl --extern socket=/tmp/mysql.sock t/select.test


-------------------------------------------------------------------------


--- /usr/local/mysql-5.5-3487/mysql-test/r/select.result	2011-05-03 15:00:59.000000000 +0300
+++ /usr/local/mysql-5.5-3487/mysql-test/r/select.reject	2011-06-15 17:09:43.126761202 +0300
@@ -133,10 +133,10 @@
 1	SIMPLE	t2	ref	fld3	fld3	30	const	1	Using where; Using index
 explain select fld3 from t2 ignore index (fld3) where fld3 = 'honeysuckle';
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	1199	Using where
+1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	1209	Using where