Bug #16730 Test "ctype_ucs" fails without "Innodb" ("classic" build)
Submitted: 23 Jan 2006 16:25 Modified: 24 Jan 2006 17:05
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:4.1.17 OS:Any (All)
Assigned to: Joerg Bruehe CPU Architecture:Any

[23 Jan 2006 16:25] Joerg Bruehe
Description:
Release build of 4.1.17.

Symptom:
-------------------------------------------------------
*** r/ctype_ucs.result
--- r/ctype_ucs.reject
***************
*** 678,683
  803D
  drop table t1;
  create table t1(f1 varchar(5) CHARACTER SET ucs2 COLLATE ucs2_bin NOT NULL) engine=InnoDB;
  insert into t1 values('a');
  create index t1f1 on t1(f1);
  select f1 from t1 where f1 like 'a%';
--- 678,685
  803D
  drop table t1;
  create table t1(f1 varchar(5) CHARACTER SET ucs2 COLLATE ucs2_bin NOT NULL) engine=InnoDB;
+ Warnings:
+ Warning       1266    Using storage engine MyISAM for table 't1'
  insert into t1 values('a');
  create index t1f1 on t1(f1);
  select f1 from t1 where f1 like 'a%';
-------------------------------------------------------

How to repeat:
Build "classic", run tests.

Suggested fix:
Similar to the one for bug#11895:
Disable warnings around "create table".
[24 Jan 2006 12:54] 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/1563
[24 Jan 2006 17:05] Joerg Bruehe
Patch was approved via IRC, is pushed.