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

Hi Øystein,
Thank you for your reply.

I am using the same storage engine (Innob I believe) and repeating the test results in different output each time.

Hiromichi


--- On Thu, 6/16/11, Øystein Grøvlen <[email protected]> wrote:

> From: Øystein Grøvlen <[email protected]>
> Subject: Re: Regression test returning different result each time it's run
> To: "Hiromichi Watari" <[email protected]>
> Cc: [email protected]
> Date: Thursday, June 16, 2011, 3:22 AM
> 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]
> 
> 

-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    http://lists.mysql.com/[email protected]