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