MySQL Bugs: #48860: backup.backup_events test fails if server is compiled without big5 character set

Bug #48860	backup.backup_events test fails if server is compiled without big5 character set
Submitted:	18 Nov 2009 9:53	Modified:	1 Dec 2009 22:12
Reporter:	Olav Sandstå	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Backup	Severity:	S3 (Non-critical)
Version:	6.0.14	OS:	Any
Assigned to:	Chuck Bell	CPU Architecture:	Any

Description:
The test backup.backup_events fails like this if the server is compiled without support for the big5 character set:

CURRENT_TEST: backup.backup_events
mysqltest: At line 307: query 'SET NAMES big5 COLLATE big5_chinese_ci' failed: 1115: Unknown character set: 'big5'

How to repeat:
On Solaris using the Sun Studio compiler I do the following:

1. Branch the latest mysql-6.0-codebase-bugfixing
2. ./BUILD/autorun.sh
3. ./configure CC=/opt/studio12/SUNWspro/bin/cc CXX=/opt/studio12/SUNWspro/bin/CC CFLAGS="-Xa -m64 -mt -g" CXXFLAGS="-m64 -mt -g" --prefix=/home/os136802/install/mysql6 --with-client-ldflags=-static --with-plugins=myisam,innobase --enable-dtrace --with-debug
4. make

Run the test:

5. cd mysql-test
6. ./mysql-test-run backup.backup_events

Suggested fix:
Test should probably check for support for big5 character set like this:

-- source include/have_big5.inc

Thank you for the bug report.

TEST                                      RESULT   TIME (ms)
------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
backup.backup_events                     [ fail ]                     
        Test ended at 2009-11-18 21:36:01                             

CURRENT_TEST: backup.backup_events
mysqltest: At line 307: query 'SET NAMES big5 COLLATE big5_chinese_ci' failed: 1115: Unknown character set: 'big5'

The result from queries just before the failure was:

The test in question, backup_events, was completely rewritten during BUG#37445 and the offending SET commands removed. The test no longer uses these character sets.

BUG#37446 was pushed to mysql-6.0-backup on 24 November.