Bug #44020 Unicode Swedish collations not working with IBMDB2I

• Submitted: 1 Apr 2009 19:45
• Modified: 14 Jul 2009 14:53
• Reporter: Tim Clark
• Status: Closed
• Category: MySQL Server: DB2SE for IBM i
• Severity: S2 (Serious)
• OS: Other (IBM i 6.1)
• Assigned to: Tim Clark
• CPU Architecture: Any
• Tags: ucs2_swedish_ci, utf8_swedish_ci

[1 Apr 2009 19:45] Tim Clark

Description:
The utf8_swedish_ci and ucs2_swedish_ci collations do not work with indexes on IBMDB2I tables.

They are not listed in the reference manual.

How to repeat:
create table t1 (c char(10) collate utf8_swedish_ci, index(c)) engine=ibmdb2i;
ERROR 1005 (HY000): Can't create table 'test.t1' (errno: 2518)

create table t1 (c char(10) collate ucs2_swedish_ci, index(c)) engine=ibmdb2i;
ERROR 1005 (HY000): Can't create table 'test.t1' (errno: 2518)

Suggested fix:
Add support for these collations.

Add these collations to the list of supported collations in the documentation.

[10 Apr 2009 6:27] 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/71846

2866 Narayanan V	2009-04-10
      Bug#44020 Unicode Swedish collations not working with IBMDB2I
      
      The utf8_swedish_ci and ucs2_swedish_ci
      collations do not work with indexes on 
      IBMDB2I tables.
      
      The current patch adds the mapping for
      ucs2_swedish collation and removes the 
      ucs2_spanish2 mapping which is not
      supported by any version of the operating
      system.
     @ storage/ibmdb2i/db2i_collationSupport.cc
        Removed mapping for ucs2_spanish2 collation
        since it is not supported by any version of the operating system. Added mapping for ucs2_swedish
        collation which had been overlooked but is
        supported by the IBM i 6.1.

[5 May 2009 19:38] Bugs System

Pushed into 5.1.35 (revid:[e-mail]-20090505190206-9xmh7dlc6kom8exp) (version source revid:[e-mail]-20090505190206-9xmh7dlc6kom8exp) (merge vers: 5.1.35) (pib:6)

[6 May 2009 14:11] Bugs System

Pushed into 6.0.12-alpha (revid:[e-mail]-20090506125450-yokcmvqf2g7jhujq) (version source revid:[e-mail]-20090413143011-ln9yuyfzrrwzh4vg) (merge vers: 6.0.11-alpha) (pib:6)

[15 Jun 2009 8:25] Bugs System

Pushed into 5.1.35-ndb-6.3.26 (revid:[e-mail]-20090615074202-0r5r2jmi83tww6sf) (version source revid:[e-mail]-20090615070837-9pccutgc7repvb4d) (merge vers: 5.1.35-ndb-6.3.26) (pib:6)

[15 Jun 2009 9:04] Bugs System

Pushed into 5.1.35-ndb-7.0.7 (revid:[e-mail]-20090615074335-9hcltksp5cu5fucn) (version source revid:[e-mail]-20090615072714-rmfkvrbbipd9r32c) (merge vers: 5.1.35-ndb-7.0.7) (pib:6)

[15 Jun 2009 9:45] Bugs System

Pushed into 5.1.35-ndb-6.2.19 (revid:[e-mail]-20090615061520-sq7ds4yw299ggugm) (version source revid:[e-mail]-20090615054654-ebgpz7elwu1xj36j) (merge vers: 5.1.35-ndb-6.2.19) (pib:6)

[14 Jul 2009 14:53] MC Brown

A note has been added to the 5.1.35, 6.0.12, 5.1.35-ndb-6.3.26, 5.1.35-ndb-6.2.19, 5.1.35-ndb-7.0.7:

The ucs2_swedish_ci and utf8_swedish_ci storage engines did not work with indexes using the IBMDB2I storage engine. Support is now provided for MySQL when running on IBM i 6.1 or higher