Bug #43383 main.variables-big : Weak testing code and result
Submitted: 4 Mar 2009 16:43 Modified: 6 May 2009 14:47
Reporter: Matthias Leich Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.0,5.1,6.0 OS:Any
Assigned to: Matthias Leich CPU Architecture:Any

[4 Mar 2009 16:43] Matthias Leich
Description:
mysql-5.0-bugteam last changeset March 2009

./mysql-test-run.pl \
    --tmpdir=/dev/shm/tmp60 \
    --vardir=/dev/shm/var60 --force \
    --suite=main --big | tee prt.main 2>&1
-----------
,,,
varbinary                      [ pass ]             32
variables-big                  [ fail ]

--- .../r/variables-big.result
+++ .../r/variables-big.reject
@@ -5,20 +5,16 @@
 set session transaction_prealloc_size=1024*1024*1024*2;
 show processlist;
 Id     User    Host    db      Command Time    State   Info
-6      root    localhost       test    Query   1       NULL    show processlist
+6      root    localhost       test    Query   0       NULL    show processlist
 set session transaction_prealloc_size=1024*1024*1024*3;
 show processlist;
 Id     User    Host    db      Command Time    State   Info
 6      root    localhost       test    Query   0       NULL    show processlist
 set session transaction_prealloc_size=1024*1024*1024*4;
-Warnings:
-Warning        1292    Truncated incorrect transaction_prealloc_size value: '4294967296'
 show processlist;
 Id     User    Host    db      Command Time    State   Info
 6      root    localhost       test    Query   0       NULL    show processlist
 set session transaction_prealloc_size=1024*1024*1024*5;
-Warnings:
-Warning        1292    Truncated incorrect transaction_prealloc_size value: '5368709120'
 show processlist;
 Id     User    Host    db      Command Time    State   Info
 6      root    localhost       test    Query   0       NULL    show processlist

mysqltest: Result content mismatch
.......

Please ignore the warnings. They must be handled within
another bug report.
A pure "show processlist;" without preceeding
   --replace_column ......
must produce lead to unstable results depending
on
- the amount of preceding tests
  (-> column Id)
- the current performance of the testing box
  (-> column Time)

MySQL 5.1 and 6.0 have the same weak test.

How to repeat:
Either
- run this test
  ./mysql-test-run --big variables-big
or 
- just read the script and imagine what could happen.
[10 Mar 2009 18:19] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/68812

2772 Matthias Leich	2009-03-10
      Fix for Bug#43383 main.variables-big : Weak testing code and result
[17 Mar 2009 13:18] Bernt Marius Johnsen
Ok to push when you have dealt with the truncation warnings that Patrick mentioned. I get the same result as him on my desktop.
[25 Mar 2009 18:29] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/70412

2778 Matthias Leich	2009-03-25
      Fix for Bug#43383 main.variables-big : Weak testing code and result
      including modifications according to code review
      + backport of the fix for
        Bug 41932 funcs_1: is_collation_character_set_applicability path
                           too long for tar
        which was missing in 5.0 (just a renaming of two files)
[26 Mar 2009 18:10] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/70577

2778 Matthias Leich	2009-03-26
      Fix for Bug#43383 main.variables-big : Weak testing code and result
      including modifications according to code review
      + backport of the fix for
        Bug 41932 funcs_1: is_collation_character_set_applicability path
                           too long for tar
        which was missing in 5.0 (just a renaming of two files)
[30 Mar 2009 15:30] Matthias Leich
Pushed to
mysql-6.0-bugteam
mysql-5.1-bugteam
mysql-5.0-bugteam
[5 May 2009 18:53] Bugs System
Pushed into 5.0.82 (revid:davi.arnaut@sun.com-20090505184158-dvmedh8n472y8np5) (version source revid:davi.arnaut@sun.com-20090505184158-dvmedh8n472y8np5) (merge vers: 5.0.82) (pib:6)
[5 May 2009 19:43] Bugs System
Pushed into 5.1.35 (revid:davi.arnaut@sun.com-20090505190206-9xmh7dlc6kom8exp) (version source revid:davi.arnaut@sun.com-20090505190206-9xmh7dlc6kom8exp) (merge vers: 5.1.35) (pib:6)
[6 May 2009 4:03] Paul DuBois
Test case changes. No changelog entry needed.

Setting report to NDI pending push into 6.0.x.
[6 May 2009 14:11] Bugs System
Pushed into 6.0.12-alpha (revid:svoj@sun.com-20090506125450-yokcmvqf2g7jhujq) (version source revid:matthias.leich@sun.com-20090330123722-ndb2y38a5noobxs1) (merge vers: 6.0.11-alpha) (pib:6)
[6 May 2009 14:47] Paul DuBois
Test case changes. No changelog entry needed.
[15 Jun 2009 8:29] Bugs System
Pushed into 5.1.35-ndb-6.3.26 (revid:jonas@mysql.com-20090615074202-0r5r2jmi83tww6sf) (version source revid:jonas@mysql.com-20090615070837-9pccutgc7repvb4d) (merge vers: 5.1.35-ndb-6.3.26) (pib:6)
[15 Jun 2009 9:09] Bugs System
Pushed into 5.1.35-ndb-7.0.7 (revid:jonas@mysql.com-20090615074335-9hcltksp5cu5fucn) (version source revid:jonas@mysql.com-20090615072714-rmfkvrbbipd9r32c) (merge vers: 5.1.35-ndb-7.0.7) (pib:6)
[15 Jun 2009 9:50] Bugs System
Pushed into 5.1.35-ndb-6.2.19 (revid:jonas@mysql.com-20090615061520-sq7ds4yw299ggugm) (version source revid:jonas@mysql.com-20090615054654-ebgpz7elwu1xj36j) (merge vers: 5.1.35-ndb-6.2.19) (pib:6)