maria-developers team mailing list archive

[Sergei Petrunia <psergey@xxxxxxxxxxxx>]

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: psergey@xxxxxxxxxxxx-20120127135140-4ues2tk6juf4iynx
> > parent: psergey@xxxxxxxxxxxx-20120126102034-tp33uzyuqnyk30mn
> > committer: Sergey Petrunya <psergey@xxxxxxxxxxxx>
> > 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@xxxxxxxxxxxxxxxxxxx
> 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