Bug #44522 main.not_embedded_server fails with "--check-testcases"
Submitted: 28 Apr 2009 14:54 Modified: 6 May 2009 4:01
Reporter: Matthias Leich Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.0 OS:Any
Assigned to: Matthias Leich CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[28 Apr 2009 14:54] Matthias Leich
Description:
mysql-5.0-bugteam last change 2009-04-21:

./mysql-test-run --check-testcases not_embedded_server
...
Installing Master Database
=======================================================
Starting Tests in the 'main' suite

TEST                 RESULT    TIME (ms)
----------------------------------------

not_embedded_server  [ fail ]

--- ...not_embedded_server.result
+++ ...not_embedded_server.reject
@@ -6,7 +6,7 @@
 FLUSH STATUS;
 SHOW GLOBAL STATUS LIKE 'com_select';
 Variable_name  Value
-Com_select     101
+Com_select     118
 SHOW GLOBAL STATUS LIKE 'com_select';
 Variable_name  Value
-Com_select     101
+Com_select     118

mysqltest: Result content mismatch

./mysql-test-run.pl not_embedded_server
...
Installing Master Database
=======================================================
Starting Tests in the 'main' suite

TEST                 RESULT    TIME (ms)
----------------------------------------

not_embedded_server  [ pass ]  13
----------------------------------------
Stopping All Servers
All 1 tests were successful.

For an explanation of the observed effect
please have a look into
Bug#42444 main.change_user: result from com_select
          differs between embedded and other runs

How to repeat:
See above

Suggested fix:
Backport of the fix for
http://bugs.mysql.com/bug.php?id=42444
to MySQL 5.0 not_embedded_server.
[28 Apr 2009 20:59] 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/72958

2732 Matthias Leich	2009-04-28
      Fix for Bug#44522 main.not_embedded_server fails with "--check-testcases"
      
      Detail:
      Backport of the solution (5.1) for
      Bug 42444 main.change_user: result from com_select differs between embedded and other runs
[29 Apr 2009 8:23] Bernt Marius Johnsen
Ok to push
[30 Apr 2009 9:41] Horst Hunger
OK to push.
[30 Apr 2009 12:05] Matthias Leich
Pushed to
   mysql-5.0-bugteam
   mysql-5.1-bugteam (*)
   mysql-6.0-bugteam (*)
(*) = no changes of files, because the fix is a backport
      5.1 -> 5.0
[30 Apr 2009 12: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/73115

2739 Matthias Leich	2009-04-30
      Merge of fix for Bug#44522 main.not_embedded_server fails with "--check-testcases"
      into actual tree
[5 May 2009 18:52] 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:41] 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:01] Paul Dubois
Test case changes. No changelog entry needed.
[6 May 2009 14:12] Bugs System
Pushed into 6.0.12-alpha (revid:svoj@sun.com-20090506125450-yokcmvqf2g7jhujq) (version source revid:sergey.glukhov@sun.com-20090430101930-931dfgo7r584v6bz) (merge vers: 6.0.11-alpha) (pib:6)
[15 Jun 2009 8:27] 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:07] 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:48] 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)