On Fri, Jan 27, 2012 at 03:27:50PM +0100, Sergei Golubchik wrote: > What do you mean? > SHOW STATUS returns a sorted list of variables.
#maria <montywi> SHOW STATUS gives things in random order this corroborates with https://internal.askmonty.org/buildbot/builders/debian5-i386-fulltest/builds/2153, 'nm' pass shows: main.myisam_mrr w1 [ pass ] 606 while 'emb' pass shows: +++ /var/lib/buildbot/maria-slave/debian5-i386-fulltest/build/mysql-test/r/myisam_mrr.reject 2012-01-26 07:08:17.000000000 -0500 @@ -563,9 +563,9 @@ flush status; show status like 'Handler_mrr%'; Variable_name Value -Handler_mrr_extra_key_sorts 0 -Handler_mrr_extra_rowid_sorts 0 Handler_mrr_init 0 +Handler_mrr_extra_rowid_sorts 0 +Handler_mrr_extra_key_sorts 0 create table t0 (a int); insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); if it gives them sorted, how the above is possible? > > On Jan 27, Sergey Petrunya wrote: > > At file:///home/psergey/dev2/5.3-look48/ > > > > revno: 3398 > > revision-id: [email protected] > > parent: [email protected] > > committer: Sergey Petrunya <[email protected]> > > branch nick: 5.3-look48 > > timestamp: Fri 2012-01-27 17:51:40 +0400 > > message: > > Make testcase stable by adding --sorted_result for SHOW STATUS commands. > Regards, > Sergei > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-developers > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-developers > More help : https://help.launchpad.net/ListHelp -- BR Sergei -- Sergei Petrunia, Software Developer Monty Program AB, http://askmonty.org Blog: http://s.petrunia.net/blog _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
