List:Internals« Previous MessageNext Message »
From:Øystein Grøvlen Date:June 16 2011 7:22am
Subject:Re: Regression test returning different result each time it's run
View as plain text  
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
>
>

Thread
Use of thread specific data with mysqldHiromichi Watari24 Apr
  • Re: Use of thread specific data with mysqldSergei Golubchik24 Apr
    • Re: Use of thread specific data with mysqldHiromichi Watari26 Apr
      • Re: Use of thread specific data with mysqldMarc Alff27 Apr
        • Re: Use of thread specific data with mysqldHiromichi Watari28 Apr
          • Re: Use of thread specific data with mysqldMats Kindahl3 May
            • Re: Use of thread specific data with mysqldHiromichi Watari4 May
            • Re: Use of thread specific data with mysqldMichael Widenius4 May
              • Regression test returning different result each time it's runHiromichi Watari15 Jun
                • Re: Regression test returning different result each time it's runØystein Grøvlen16 Jun
                  • Re: Regression test returning different result each time it's runHiromichi Watari16 Jun
                    • Re: Regression test returning different result each time it's runØystein Grøvlen16 Jun
                      • Re: Regression test returning different result each time it's runRick James16 Jun
                        • Re: Regression test returning different result each time it's runHiromichi Watari18 Jun
                      • Re: Regression test returning different result each time it's runHiromichi Watari18 Jun
                        • Name of function to execute mysql commandHiromichi Watari21 Jan