From: Hiromichi Watari
Date: June 16 2011 2:10pm
Subject: Re: Regression test returning different result each time it's run
List-Archive: http://lists.mysql.com/internals/38340
Message-Id: <122594.91966.qm@web121514.mail.ne1.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi =D8ystein,
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, =D8ystein Gr=F8vlen <oystein.grovlen@stripped> wrote=
:

> From: =D8ystein Gr=F8vlen <oystein.grovlen@stripped>
> Subject: Re: Regression test returning different result each time it's ru=
n
> To: "Hiromichi Watari" <hiromichiwatari@stripped>
> Cc: internals@stripped
> 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 ?=A0 Or am I missing
> something ?
>=20
> The difference is in the estimated number of rows in table
> t2.=A0 This=20
> number is provided by the storage engine.=A0 Maybe you
> are using a=20
> different storage engine?
>=20
> Hope this helps,
>=20
> --=20
> =D8ystein Gr=F8vlen, Principal Software Engineer
> MySQL Group, Oracle
> Trondheim, Norway
>=20
> >
> > 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=3D/tmp/mysql.sock
> t/select.test
> >
> >
> >
> -------------------------------------------------------------------------
> >
> >
> > ---
> /usr/local/mysql-5.5-3487/mysql-test/r/select.result=A0=A0=A0
> 2011-05-03 15:00:59.000000000 +0300
> > +++
> /usr/local/mysql-5.5-3487/mysql-test/r/select.reject=A0=A0=A0
> 2011-06-15 17:09:43.126761202 +0300
> > @@ -133,10 +133,10 @@
> >=A0=A0=A01=A0=A0=A0
> SIMPLE=A0=A0=A0 t2=A0=A0=A0
> ref=A0=A0=A0 fld3=A0=A0=A0
> fld3=A0=A0=A0 30=A0=A0=A0
> const=A0=A0=A0 1=A0=A0=A0 Using where;
> Using index
> >=A0=A0=A0explain select fld3 from t2 ignore
> index (fld3) where fld3 =3D 'honeysuckle';
> >=A0=A0=A0id=A0=A0=A0
> select_type=A0=A0=A0 table=A0=A0=A0
> type=A0=A0=A0 possible_keys=A0=A0=A0
> key=A0=A0=A0 key_len=A0=A0=A0
> ref=A0=A0=A0 rows=A0=A0=A0 Extra
> > -1=A0=A0=A0 SIMPLE=A0=A0=A0
> t2=A0=A0=A0 ALL=A0=A0=A0
> NULL=A0=A0=A0 NULL=A0=A0=A0
> NULL=A0=A0=A0 NULL=A0=A0=A0
> 1199=A0=A0=A0 Using where
> > +1=A0=A0=A0 SIMPLE=A0=A0=A0
> t2=A0=A0=A0 ALL=A0=A0=A0
> NULL=A0=A0=A0 NULL=A0=A0=A0
> NULL=A0=A0=A0 NULL=A0=A0=A0
> 1209=A0=A0=A0 Using where
> >
> >
>=20
>=20
> --=20
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe:=A0 =A0 http://lists.mysql.com/internals?unsub=3Dhiromichi=
watari@stripped
>=20
>