Bug #40209 Test "charset_collation_3" not adapted to new UTF encodings in 6.0
Submitted: 21 Oct 2008 13:33 Modified: 10 Jul 2009 15:21
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:6.0.8-alpha,5.4 OS:Any
Assigned to: Matthias Leich CPU Architecture:Any

[21 Oct 2008 13:33] Joerg Bruehe
Description:
This is the start of the test failure difference:

=====
funcs_1.charset_collation_3    [ fail ]

--- /PATH/mysql-test/suite/funcs_1/r/charset_collation_3.result
+++ /PATH/mysql-test/suite/funcs_1/r/charset_collation_3.reject
@@ -41,7 +41,10 @@
 tis620 tis620_thai_ci  TIS620 Thai     1
 ucs2   ucs2_general_ci UCS-2 Unicode   2
 ujis   ujis_japanese_ci        EUC-JP Japanese 3
-utf8   utf8_general_ci UTF-8 Unicode   3
+utf16  utf16_general_ci        UTF-16 Unicode  4
+utf32  utf32_general_ci        UTF-32 Unicode  4
+utf8   utf8_general_ci UTF-8 Unicode   4
+utf8mb3        utf8mb3_general_ci      UTF-8 Unicode   3

 SELECT *
 FROM information_schema.collations
@@ -144,6 +147,7 @@
 ucs2_polish_ci ucs2    133             Yes     8
 ucs2_romanian_ci       ucs2    131             Yes     8
 ucs2_roman_ci  ucs2    143             Yes     8
+ucs2_sinhala_ci        ucs2    147             Yes     8
 ucs2_slovak_ci ucs2    141             Yes     8
 ucs2_slovenian_ci      ucs2    132             Yes     8
 ucs2_spanish2_ci       ucs2    142             Yes     8
@@ -153,27 +157,94 @@
 ucs2_unicode_ci        ucs2    128             Yes     8
 ujis_bin       ujis    91              Yes     1
 ujis_japanese_ci       ujis    12      Yes     Yes     1
-utf8_bin       utf8    83              Yes     1
-utf8_czech_ci  utf8    202             Yes     8
-utf8_danish_ci utf8    203             Yes     8
.....
+utf16_bin      utf16   55              Yes     1
+utf16_czech_ci utf16   111             Yes     8
+utf16_danish_ci        utf16   112             Yes     8
.....
+utf32_bin      utf32   61              Yes     1
+utf32_czech_ci utf32   170             Yes     8
+utf32_danish_ci        utf32   171             Yes     8
.....
+utf8mb3_bin    utf8mb3 83              Yes     1
+utf8mb3_czech_ci       utf8mb3 202             Yes     8
+utf8mb3_danish_ci      utf8mb3 203             Yes     8
.....
+utf8_bin       utf8    46              Yes     1
+utf8_czech_ci  utf8    234             Yes     8
+utf8_danish_ci utf8    235             Yes     8
.....
=====

How to repeat:
Run the *full* test suite.
[10 Nov 2008 17:05] Matthias Leich
Please fix
Bug#40618 funcs_1.charset_collation_3 fails, scripts
          and or results need maintenance
first. The merge 5.1 -> 6.0 will force to fix the
current bug.
[12 Nov 2008 17:42] Matthias Leich
Switching lead from Manyi to Georgi Kodinov
because the merge 5.1 -> 6.0 of the fix for
Bug#40618 funcs_1.charset_collation_3 fails, 
          scripts and or results need maintenance
   (5.1+, Lead: Georgi)
should fix the current bug.
[30 Mar 2009 15:35] Matthias Leich
charset_collation_3 is now disabled.

It might be enabled again or replaced by another test
if there is a solution for the character set/collation
related Bug#38346, Bug#40209, Bug#40545, Bug#40618
[5 May 2009 17:04] 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/73408

2735 Matthias Leich	2009-05-05
      Fix for Bug#40545, Bug#40209, Bug#40618, Bug#38346
      
      Details:
      - Limit the queries to character sets and collations
        which are most probably available in all build types.
        But try to preserve the intention of the tests.
      - Remove the variants adjusted to some build types.
      
      Note:
        I am not able to check the correctness of this patch
        on any existing build type and any MySQL version.
        So it could happen that the new test fails somewhere.
[4 Jun 2009 21:46] Patrick Crews
Ok to push.
Patch alters outdated testing requirements and provides a more robust and basic test.
[19 Jun 2009 15:04] 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/76720

2735 Matthias Leich	2009-06-19
      Fix for Bug#40545, Bug#40209, Bug#40618, Bug#38346
      
        Details:
        - Limit the queries to character sets and collations
          which are most probably available in all build types.
          But try to preserve the intention of the tests.
        - Remove the variants adjusted to some build types.
      
        Note:
        1. The results of the review by Bar are included.
        2. I am not able to check the correctness of this patch
           on any existing build type and any MySQL version.
           So it could happen that the new test fails somewhere.
[19 Jun 2009 17:40] Matthias Leich
Pushed to
mysql-pe
mysql-5.1-bugteam
mysql-5.0-bugteam
[7 Jul 2009 7:52] Bugs System
Pushed into 5.0.84 (revid:joro@sun.com-20090707074938-ksah1ibn0vs92cem) (version source revid:matthias.leich@sun.com-20090619152120-h73s7h6mfoijjbwm) (merge vers: 5.0.84) (pib:11)
[8 Jul 2009 13:30] Bugs System
Pushed into 5.1.37 (revid:joro@sun.com-20090708131116-kyz8iotbum8w9yic) (version source revid:matthias.leich@sun.com-20090619154429-vxyjl2wmdj4bnxl6) (merge vers: 5.1.36) (pib:11)
[9 Jul 2009 7:35] Bugs System
Pushed into 5.0.84 (revid:joro@sun.com-20090707074938-ksah1ibn0vs92cem) (version source revid:matthias.leich@sun.com-20090619152120-h73s7h6mfoijjbwm) (merge vers: 5.0.84) (pib:11)
[9 Jul 2009 7:36] Bugs System
Pushed into 5.1.37 (revid:joro@sun.com-20090708131116-kyz8iotbum8w9yic) (version source revid:matthias.leich@sun.com-20090619154429-vxyjl2wmdj4bnxl6) (merge vers: 5.1.36) (pib:11)
[10 Jul 2009 11:20] Bugs System
Pushed into 5.4.4-alpha (revid:anozdrin@bk-internal.mysql.com-20090710111017-bnh2cau84ug1hvei) (version source revid:matthias.leich@sun.com-20090619161437-4r189dusbbdv1jrg) (merge vers: 5.4.4-alpha) (pib:11)
[10 Jul 2009 15:21] Paul DuBois
Test case changes. No changelog entry needed.
[26 Aug 2009 13:46] Bugs System
Pushed into 5.1.37-ndb-7.0.8 (revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)
[26 Aug 2009 13:46] Bugs System
Pushed into 5.1.37-ndb-6.3.27 (revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (version source revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (merge vers: 5.1.37-ndb-6.3.27) (pib:11)
[26 Aug 2009 13:48] Bugs System
Pushed into 5.1.37-ndb-6.2.19 (revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (version source revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (merge vers: 5.1.37-ndb-6.2.19) (pib:11)
[27 Aug 2009 16:32] Bugs System
Pushed into 5.1.35-ndb-7.1.0 (revid:magnus.blaudd@sun.com-20090827163030-6o3kk6r2oua159hr) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)