Regression test returning different result each time it's run

Hiromichi Watari <[email protected]>
Newsgroups gmane.comp.db.mysql.devel
Message-ID <[email protected]>
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


-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.