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
