Bug #37164 funcs_1: Some tests fail if an optional character set is missing.
Submitted: 3 Jun 2008 16:28 Modified: 10 Jul 2008 19:50
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

[3 Jun 2008 16:28] Matthias Leich
Description:
Run of funcs_1 on a special build where a lot
of character sets/collations are not compiled in/disabled.

innodb_trig_frkey
is_columns_<engine>
is_tables_<engine>

charset_collation_1 fails also, but for this we already have
Bug#36787 Test funcs_1.charset_collation_1 failing

How to repeat:
Have a release where for the ucs2 character set
is missing.
   cd mysql-test
   ./mysql-test-run.pl --suite=funcs_1
or
   Look into the source code of the tests.
   They try to create a table where a column has
   the attribute unicode, but miss the
   necessary
   "--source include/have_ucs2".

Suggested fix:
1. innodb_trig_frkey
   is_tables_<engine>
   Remove the unicode attribute from the corresponding
   columns. The coverage will not decrease because the
   affected tests do not check things around unicode.
2. is_columns_<engine>
   Split this test into
      - is_columns_<engine>
        = old test without unicode columns
      - is_cml_<engine>
        = old test with unicode columns, but it will be
          skipped if a necessary characterset is missing
[11 Jun 2008 15:23] Patrick Crews
Ok to push.  

Minor comments sent to developer for consideration.
[20 Jun 2008 15:56] Matthias Leich
Patch was pushed to
mysql-5.0-bugteam
mysql-5.1-bugteam
mysql-6.0-bugteam
[26 Jun 2008 13:40] Bugs System
Pushed into 5.0.66
[26 Jun 2008 13:40] Bugs System
Pushed into 5.0.64
[10 Jul 2008 19:50] Paul DuBois
Test case changes. No changelog entry needed.
[28 Jul 2008 13:47] Bugs System
Pushed into 5.0.68  (revid:kpettersson@mysql.com-20080715152926-s5kgnqhtu93b3c8v) (pib:2)
(Retry automatic marking, to ensure nothing is missed. cm01)
[28 Jul 2008 16:50] Bugs System
Pushed into 5.1.27  (revid:joerg@mysql.com-20080626161101-h5hsaluwtf05xdr2) (version source revid:joerg@mysql.com-20080626161101-h5hsaluwtf05xdr2) (pib:3)