Re: Regression test returning different result each time it's run

On 15/06/2011 17:08, Hiromichi Watari wrote:
> 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 ?

The difference is in the estimated number of rows in table t2.  This 
number is provided by the storage engine.  Maybe you are using a 
different storage engine?

Hope this helps,

-- 
Øystein Grøvlen, Principal Software Engineer
MySQL Group, Oracle
Trondheim, Norway

>
> 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]