| 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: | |
| Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
| Version: | 5.0,5.1,6.0 | OS: | Any |
| Assigned to: | Matthias Leich | CPU Architecture: | Any |
[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)
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.