Bug #43546 Several 5.0 tests do not pass MTR's --check option (moved from Bug 42308)
Submitted: 10 Mar 2009 21:33 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

[10 Mar 2009 21:33] Matthias Leich
Description:
It is necessary to split
Bug#42308 Several server tests do not pass MTR's
          --check option
because the amount of test to modify and the
complexity of merges and testing not acceptable.

Tests which do not satisfy "--check-testcases"
when executed in 5.0 trees:
----------------------------------------------
- init_file:
  To be handled via
  Bug#42507 mtr2: the --check is fooled up by a code
             executed in --init_file
- mysql_client_test:
  The test passes "--check-testcases".
  But the file mysql_client_test.out.log is generated
  by the test and not removed. The content if this file
  is not deterministic (Example: date/time of test
  execution is included). I assume that the content
  of this log is needed in case the test fails.
  --> I will not fix this.
- innodb-autoinc-optimize
- innodb
- insert_update
- status

How to repeat:
./mysql-test-run.pl --force --big --check-testcases
[23 Apr 2009 16:21] 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/72720

2730 Matthias Leich	2009-04-23
      Fix for Bug#43546 Several 5.0 tests do not pass MTR's --check option (moved from Bug#42308)
      
      Details:
      insert_update, innodb-autoinc-optimize
         Add the DROP TABLE which was missing
      innodb_notembedded
         Take care that the disconnects of additional sessions are completed
[24 Apr 2009 10:37] Bernt Marius Johnsen
mysql_client_test.out.log is the output from mysql_client_test and contains needed information if the test fails.
[24 Apr 2009 13:59] Matthias Leich
The imperfect test "innodb" wil be handled in another bug.
"status" is already fixed.
[24 Apr 2009 16:46] Patrick Crews
Ok to push.
[24 Apr 2009 18:09] 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/72799

2730 Matthias Leich	2009-04-24
      Fix for Bug#43546 Several 5.0 tests do not pass MTR's --check option (moved from Bug#42308)
      
      Details:
      - insert_update
        Add DROP TABLE which was missing, error numbers -> names
      - innodb-autoinc-optimize, varbinary
        Add DROP TABLE which was missing
      - innodb_notembedded
        Take care that the disconnects of additional sessions are completed
      - sp_trans_log
        Add missing DROP function, improved formatting
[27 Apr 2009 13:01] Matthias Leich
Bug#44493 Fix InnoDB owned 5.0 tests with imperfect cleanup
takes care of the "Innodb owned" tests:
   innodb-autoinc-optimize
   innodb_notembedded
   innodb
[27 Apr 2009 13:11] 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/72840

2730 Matthias Leich	2009-04-27
      Fix for Bug#43546 Several 5.0 tests do not pass MTR's --check option (moved from Bug 42308)
      
      Details:
         - insert_update
           Add DROP TABLE which was missing, error numbers -> names
         - varbinary
           Add DROP TABLE which was missing
         - sp_trans_log
           Add missing DROP function, improved formatting
[28 Apr 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/72933

2735 Matthias Leich	2009-04-28
      Fix for Bug#43546 Several 5.0 tests do not pass MTR's --check option
                        (moved from Bug 42308)
      
      Details:
      - insert_update
        Add DROP TABLE which was missing, error numbers -> names
      - varbinary
        Add DROP TABLE which was missing
      - sp_trans_log
        Add missing DROP function, improved formatting
[28 Apr 2009 20:05] Matthias Leich
Pushed to
mysql-6.0-bugteam
mysql-5.1-bugteam
mysql-5.0-bugteam
[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:39] 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:02] 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:holyfoot@mysql.com-20090429043953-xrupk7aoxbyz3c61) (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:26] 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:06] 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:46] 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)