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å
• Status: Closed
• 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

[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        [e-mail]     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	[e-mail]-20090106090927-54wm65pm0r98x59l
Push Date	2009-01-06 11:27:09

[13 Feb 2009 7:24] Bugs System

Pushed into 6.0.10-alpha (revid:[e-mail]-20090211182317-uagkyj01fk30p1f8) (version source revid:[e-mail]-20090113103017-41jbad7qlvlwpwxh) (merge vers: 6.0.10-alpha) (pib:6)

[7 May 2009 16:56] MC Brown

Internal/test fix. No changelog entry required.