• V Narayanan's avatar
    Bug#45196 Some collations do not sort correctly with IBMDB2I · 3ad7e45a
    V Narayanan authored
    Some collations--including cp1250_czech_cs,latin2_czech_cs,
    ucs2/utf8_czech_ci, ucs2/utf8_danish_ci--are not being
    sorted correctly by the IBMDB2I storage engine. This
    was being caused because the sort order used by DB2 is
    incompatible with the order expected by MySQL.
    
    This patch removes support for the cp1250_czech_cs and
    latin2_czech_cs collations because it has been determined
    that the sort order used by DB2 is incompatible with the
    order expected by MySQL. Users needing a czech collation
    with IBMDB2I are encouraged to use a Unicode-based collation 
    instead of these single-byte collations. This patch also
    modifies the DB2 sort sequence used for ucs2/utf8_czech_ci
    and ucs2/utf8_danish_ci collations to better match the
    sorting expected by MySQL. This will only affect indexes
    or tables that are newly created through the IBMDB2I storage
    engine. Existing IBMDB2I tables will retain the old sort
    sequence until recreated.
    
    mysql-test/suite/ibmdb2i/r/ibmdb2i_bug_45196.result:
      Bug#45196  Some collations do not sort correctly with IBMDB2I
      
      Result file for the test case.
    mysql-test/suite/ibmdb2i/t/ibmdb2i_bug_45196.test:
      Bug#45196  Some collations do not sort correctly with IBMDB2I
      
      Adding tests for testing the sort order with the modified collations.
    storage/ibmdb2i/db2i_collationSupport.cc:
      Bug#45196  Some collations do not sort correctly with IBMDB2I
      
      Remove the support for the cp1250_czech_cs and latin2_czech_cs 
      collations because it has been determined that the sort order
      used by DB2 is incompatible with the order expected by MySQL.
      Users needing a czech collation with IBMDB2I are encouraged to
      use a Unicode-based collation instead of these single-byte
      collations. This patch also modifies the DB2 sort sequence
      used for ucs2/utf8_czech_ci and ucs2/utf8_danish_ci collations
      to better match the sorting expected by MySQL. This will only 
      affect indexes or tables that are newly created through the
      IBMDB2I storage engine. Existing IBMDB2I tables will retain
      the old sort sequence until recreated.
    3ad7e45a
db2i_collationSupport.cc 9.56 KB