MySQL Bugs: #37164: funcs_1: Some tests fail if an optional character set is missing.

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

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

Ok to push.  

Minor comments sent to developer for consideration.

Patch was pushed to
mysql-5.0-bugteam
mysql-5.1-bugteam
mysql-6.0-bugteam

Pushed into 5.0.66

Pushed into 5.0.64

Test case changes. No changelog entry needed.

Pushed into 5.0.68  (revid:kpettersson@mysql.com-20080715152926-s5kgnqhtu93b3c8v) (pib:2)
(Retry automatic marking, to ensure nothing is missed. cm01)

Pushed into 5.1.27  (revid:joerg@mysql.com-20080626161101-h5hsaluwtf05xdr2) (version source revid:joerg@mysql.com-20080626161101-h5hsaluwtf05xdr2) (pib:3)