Bug #42711 test with imperfect cleanup
Submitted: 9 Feb 2009 18:53 Modified: 18 Mar 2009 15:51
Reporter: Matthias Leich Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Bernt Marius Johnsen CPU Architecture:Any

[9 Feb 2009 18:53] Matthias Leich
Description:
During experiments with a prototype of an improved
include/check-testcase.test I found the following
suspicious tests:
--------------------------------------------------
Base for the experiments was
   mysql-5.1-bugteam (last changeset 2009-02-05)
but many of the tests mentioned exist also in 5.0.
It is to be expected that the issues exist often
also there.
Therefore I set the Traget Version to 5.0+.
 
main.show_check
     show_check.mysqltest1.sql
main.backup:
     t@002b1.MYD , t@002b1.frm
main.ddl_i18n_koi8r:
     ddl_i18n_koi8r.events.mysqltest1.sql
     ddl_i18n_koi8r.events.mysqltest2.sql
     ddl_i18n_koi8r.sp.mysqltest1.sql
     ddl_i18n_koi8r.sp.mysqltest2.sql
     ddl_i18n_koi8r.triggers.mysqltest1.sql
     ddl_i18n_koi8r.triggers.mysqltest2.sql
     ddl_i18n_koi8r.views.mysqltest1.sql
main.ddl_i18n_utf8:
     ddl_i18n_utf8events.mysqltest1.sql
     ddl_i18n_utf8events.mysqltest2.sql
     ddl_i18n_utf8sp.mysqltest1.sql
     ddl_i18n_utf8sp.mysqltest2.sql
     ddl_i18n_utf8triggers.mysqltest1.sql
     ddl_i18n_utf8triggers.mysqltest2.sql
     ddl_i18n_utf8views.mysqltest1.sql
main.drop:
     bug29958.proc.MYD
     bug29958.proc.MYI
     bug29958.proc.frm   
main.mysqldump-compat:
     bug30126.sql
main.mysql:
     bug20103.sql
     bug20328_1.result
     bug20328_2.result
     bug20432.sql
main.sp:
     t1.MYD
     t1.frm
main.mysqlbinlog:
     SQL_LOAD_MB-1-0
     ...
     SQL_LOAD_MB-c-0
     bug31611.sql
     bug31793.sql
main.mysqltest:
     zero_length_file.reject

How to repeat:
Check var/tmp before and after running the testcase.
[9 Feb 2009 19:57] Sveta Smirnova
Thank you for the report.

Verified as described using 5.1 bzr tree.
[27 Feb 2009 11:50] Bernt Marius Johnsen
main.backup: Applies only to 5.1+ and has been fixed as part BUG#42003
[27 Feb 2009 12:23] Bernt Marius Johnsen
Only in 5.1+: main.ddl_i18n_koi8r, main.ddl_i18n_utf8, main.drop, moved to BUG#43258

main.sp: Fixed as part of BUG#38823

main.mysqlbinlog: Filed as separate bug BUG#43259
[27 Feb 2009 13:24] 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/67852
[27 Feb 2009 13:40] Bernt Marius Johnsen
Patch uploadred since the plaintext got bas64-encoded

Attachment: 42711.patch (text/x-patch), 6.63 KiB.

[27 Feb 2009 14:19] Patrick Crews
Ok to push.
[2 Mar 2009 10:03] 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/67963
[2 Mar 2009 10:24] 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/67965
[2 Mar 2009 12:43] 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/67979
[9 Mar 2009 14:13] Bugs System
Pushed into 5.0.79 (revid:joro@sun.com-20090309135922-a0di9ebkxoj4d4wv) (version source revid:bernt.johnsen@sun.com-20090302132657-xteojdldvn326adt) (merge vers: 5.0.79) (pib:6)
[13 Mar 2009 17:03] Paul DuBois
Test case changes. No changelog entry needed.

Setting report to NDI pending push into 5.1.x/6.0.x.
[13 Mar 2009 19:06] Bugs System
Pushed into 5.1.33 (revid:joro@sun.com-20090313111355-7bsi1hgkvrg8pdds) (version source revid:zhou.li@sun.com-20090311061050-ihp0g77znonq1tuq) (merge vers: 5.1.33) (pib:6)
[13 Mar 2009 20:23] Paul DuBois
Test case changes. No changelog entry needed.

Setting report to NDI pending push into 6.0.x.
[18 Mar 2009 13:20] Bugs System
Pushed into 6.0.11-alpha (revid:joro@sun.com-20090318122208-1b5kvg6zeb4hxwp9) (version source revid:bernt.johnsen@sun.com-20090302130237-ipu1bbw3d09sem88) (merge vers: 6.0.10-alpha) (pib:6)
[18 Mar 2009 15:51] Paul DuBois
Test case changes. No changelog entry needed.
[9 May 2009 16:45] Bugs System
Pushed into 5.1.34-ndb-6.2.18 (revid:jonas@mysql.com-20090508185236-p9b3as7qyauybefl) (version source revid:jonas@mysql.com-20090508100057-30ote4xggi4nq14v) (merge vers: 5.1.33-ndb-6.2.18) (pib:6)
[9 May 2009 17:42] Bugs System
Pushed into 5.1.34-ndb-6.3.25 (revid:jonas@mysql.com-20090509063138-1u3q3v09wnn2txyt) (version source revid:jonas@mysql.com-20090508175813-s6yele2z3oh6o99z) (merge vers: 5.1.33-ndb-6.3.25) (pib:6)
[9 May 2009 18:39] Bugs System
Pushed into 5.1.34-ndb-7.0.6 (revid:jonas@mysql.com-20090509154927-im9a7g846c6u1hzc) (version source revid:jonas@mysql.com-20090509073226-09bljakh9eppogec) (merge vers: 5.1.33-ndb-7.0.6) (pib:6)