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..., '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: psergey@askmonty.org-20120127135140-4ues2tk6juf4iynx parent: psergey@askmonty.org-20120126102034-tp33uzyuqnyk30mn committer: Sergey Petrunya 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 : maria-developers@lists.launchpad.net 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