Bug #41877 falcon_bugs test fails if MySQL is compiled without ucs2 support
Submitted: 5 Jan 2009 17:01 Modified: 7 May 2009 16:56
Reporter: Olav Sandstå Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0.10 OS:Any
Assigned to: John Embretsen CPU Architecture:Any
Tags: F_TEST
Triage: Triaged: D3 (Medium)

[5 Jan 2009 17:01] Olav Sandstå
Description:
When trying to run the falcon_bugs test like this:

./mysql-test-run --suite=falcon --mem --force falcon_bugs

using a MySQL that has been compiled without support for ucs2, the test fails with the following output:

mysqltest: At line 273: query 'CREATE TABLE t1 (a varchar(8)) DEFAULT CHARSET ucs2' failed: 1115: Unknown character set: 'ucs2'

The result from queries just before the failure was:
< snip >
2       4leluys0vf1c10e9q2a5iog0hfubks5p        wjrs2htec8@pb82n6mjh362j5663i6m.com     50ce8   2006-04-20              04k675wjvgbxjfsze182t5sm        8       pppbc   131
drop table t1;
*** Bug #91 ***
SET @@storage_engine = Falcon;
create table t1 (C001 VARCHAR(1000) CHARACTER SET utf8, PRIMARY KEY (C001(255)));
DROP TABLE t1;
*** Bug #122 ***
SET @@storage_engine = Falcon;
CREATE TABLE IF NOT EXISTS `falcon` (
`id` int(10) unsigned NOT NULL,
`f2` int(10) NOT NULL,
`f3` int(10) NOT NULL,
PRIMARY KEY (`id`),
KEY `f3` (`f3`)
);
DROP TABLE falcon;
*** Bug #115 ***
SET @@storage_engine = Falcon;
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a varchar(8)) DEFAULT CHARSET ucs2;

How to repeat:
1. Compile MySQL with Falcon with the following configure command:

   ./configure --with-plugins=falcon,partition

2. Run the falcon_bugs test:

   ./mysql-test-run --suite=falcon falcon_bugs

     

Suggested fix:
The test should check/require that MySQL is compiled with support for ucs2.
[6 Jan 2009 8:53] John Embretsen
Verified in latest mysql-6.0-falcon-team branch.
I'll fix it right away.
[6 Jan 2009 9: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/62509

2955 John H. Embretsen	2009-01-06
      Fix for Bug#41877 - falcon_bugs test fails if MySQL is compiled without ucs2 support.
      Added check for UCS2 support in falcon_bugs test.
[6 Jan 2009 9:13] John Embretsen
Olav, the fix I just committed will make sure the falcon_bugs test is skipped if UCS2 support is not compiled in:

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

falcon.falcon_bugs             [ skipped ]   Test requires: 'have_ucs2'

This looks OK to you?
[6 Jan 2009 10:20] Olav Sandstå
Patch looks correct. I have verified that before applying the patch the test will fail if run with a MySQL compiled without UCS2 support while after applying the patch the test will not get run.
[7 Jan 2009 11:54] John Embretsen
Patch pushed to mysql-6.0-falcon-team branch.
Push Revision	john.embretsen@sun.com-20090106090927-54wm65pm0r98x59l
Push Date	2009-01-06 11:27:09
[13 Feb 2009 7:24] Bugs System
Pushed into 6.0.10-alpha (revid:alik@sun.com-20090211182317-uagkyj01fk30p1f8) (version source revid:olav@sun.com-20090113103017-41jbad7qlvlwpwxh) (merge vers: 6.0.10-alpha) (pib:6)
[7 May 2009 16:56] MC Brown
Internal/test fix. No changelog entry required.