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
• Status: Closed
• 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:[e-mail]-20090505184158-dvmedh8n472y8np5) (version source revid:[e-mail]-20090505184158-dvmedh8n472y8np5) (merge vers: 5.0.82) (pib:6)

[5 May 2009 19:39] Bugs System

Pushed into 5.1.35 (revid:[e-mail]-20090505190206-9xmh7dlc6kom8exp) (version source revid:[e-mail]-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:[e-mail]-20090506125450-yokcmvqf2g7jhujq) (version source revid:[e-mail]-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:[e-mail]-20090615074202-0r5r2jmi83tww6sf) (version source revid:[e-mail]-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:[e-mail]-20090615074335-9hcltksp5cu5fucn) (version source revid:[e-mail]-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:[e-mail]-20090615061520-sq7ds4yw299ggugm) (version source revid:[e-mail]-20090615054654-ebgpz7elwu1xj36j) (merge vers: 5.1.35-ndb-6.2.19) (pib:6)