Bug #44020 Unicode Swedish collations not working with IBMDB2I

Submitted: 1 Apr 2009 19:45 Modified: 14 Jul 2009 14:53
Reporter: Tim Clark Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DB2SE for IBM i Severity:S2 (Serious)
Version: 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:davi.arnaut@sun.com-20090505190206-9xmh7dlc6kom8exp) (version source revid:davi.arnaut@sun.com-20090505190206-9xmh7dlc6kom8exp) (merge vers: 5.1.35) (pib:6)
[6 May 2009 14:11] Bugs System
Pushed into 6.0.12-alpha (revid:svoj@sun.com-20090506125450-yokcmvqf2g7jhujq) (version source revid:chad@mysql.com-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:jonas@mysql.com-20090615074202-0r5r2jmi83tww6sf) (version source revid:jonas@mysql.com-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:jonas@mysql.com-20090615074335-9hcltksp5cu5fucn) (version source revid:jonas@mysql.com-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:jonas@mysql.com-20090615061520-sq7ds4yw299ggugm) (version source revid:jonas@mysql.com-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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.