Bug #38346 Test "charset_collation_3" failure in community tree
Submitted: 24 Jul 2008 12:38 Modified: 10 Jul 2009 15:21
Reporter: Jonathan Perkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Packaging Severity:S3 (Non-critical)
Version:5.0.67, 5.1.27 OS:Any
Assigned to: Matthias Leich CPU Architecture:Any
Tags: disabled

[24 Jul 2008 12:38] Jonathan Perkin
Description:
New test failure from the recent 5.0.67 community build

charset_collation_3            [ fail ]

--- /PATH/mysql-test/suite/funcs_1/r/charset_collation_3.result    2008-07-21 15:27:06.000000000 +0300
+++ /PATH/mysql-test/suite/funcs_1/r/charset_collation_3.reject    2008-07-21 18:52:50.000000000 +0300
@@ -47,10 +47,10 @@
 FROM information_schema.collations
 ORDER BY collation_name;
 COLLATION_NAME CHARACTER_SET_NAME      ID      IS_DEFAULT      IS_COMPILED     SORTLEN
-armscii8_bin   armscii8        64              Yes     1
-armscii8_general_ci    armscii8        32      Yes     Yes     1
-ascii_bin      ascii   65              Yes     1
-ascii_general_ci       ascii   11      Yes     Yes     1
+armscii8_bin   armscii8        64                      0
+armscii8_general_ci    armscii8        32      Yes             0
+ascii_bin      ascii   65                      0
+ascii_general_ci       ascii   11      Yes             0
 big5_bin       big5    84              Yes     1
 big5_chinese_ci        big5    1       Yes     Yes     1
 binary binary  63      Yes     Yes     1
@@ -58,26 +58,26 @@
 cp1250_croatian_ci     cp1250  44              Yes     1
 cp1250_czech_cs        cp1250  34              Yes     2
 cp1250_general_ci      cp1250  26      Yes     Yes     1
-cp1251_bin     cp1251  50              Yes     1
-cp1251_bulgarian_ci    cp1251  14              Yes     1
-cp1251_general_ci      cp1251  51      Yes     Yes     1
-cp1251_general_cs      cp1251  52              Yes     1
-cp1251_ukrainian_ci    cp1251  23              Yes     1
-cp1256_bin     cp1256  67              Yes     1
-cp1256_general_ci      cp1256  57      Yes     Yes     1
-cp1257_bin     cp1257  58              Yes     1
-cp1257_general_ci      cp1257  59      Yes     Yes     1
-cp1257_lithuanian_ci   cp1257  29              Yes     1
-cp850_bin      cp850   80              Yes     1
-cp850_general_ci       cp850   4       Yes     Yes     1
-cp852_bin      cp852   81              Yes     1
-cp852_general_ci       cp852   40      Yes     Yes     1
-cp866_bin      cp866   68              Yes     1
-cp866_general_ci       cp866   36      Yes     Yes     1
+cp1251_bin     cp1251  50                      0
+cp1251_bulgarian_ci    cp1251  14                      0
+cp1251_general_ci      cp1251  51      Yes             0
+cp1251_general_cs      cp1251  52                      0
+cp1251_ukrainian_ci    cp1251  23                      0
+cp1256_bin     cp1256  67                      0
+cp1256_general_ci      cp1256  57      Yes             0
+cp1257_bin     cp1257  58                      0
+cp1257_general_ci      cp1257  59      Yes             0
+cp1257_lithuanian_ci   cp1257  29                      0
+cp850_bin      cp850   80                      0
+cp850_general_ci       cp850   4       Yes             0
+cp852_bin      cp852   81                      0
+cp852_general_ci       cp852   40      Yes             0
+cp866_bin      cp866   68                      0
+cp866_general_ci       cp866   36      Yes             0
 cp932_bin      cp932   96              Yes     1
 cp932_japanese_ci      cp932   95      Yes     Yes     1
-dec8_bin       dec8    69              Yes     1
-dec8_swedish_ci        dec8    3       Yes     Yes     1
+dec8_bin       dec8    69                      0
+dec8_swedish_ci        dec8    3       Yes             0
 eucjpms_bin    eucjpms 98              Yes     1
 eucjpms_japanese_ci    eucjpms 97      Yes     Yes     1
 euckr_bin      euckr   85              Yes     1
@@ -86,20 +86,20 @@
 gb2312_chinese_ci      gb2312  24      Yes     Yes     1
 gbk_bin        gbk     87              Yes     1
 gbk_chinese_ci gbk     28      Yes     Yes     1
-geostd8_bin    geostd8 93              Yes     1
-geostd8_general_ci     geostd8 92      Yes     Yes     1
-greek_bin      greek   70              Yes     1
-greek_general_ci       greek   25      Yes     Yes     1
-hebrew_bin     hebrew  71              Yes     1
-hebrew_general_ci      hebrew  16      Yes     Yes     1
-hp8_bin        hp8     72              Yes     1
-hp8_english_ci hp8     6       Yes     Yes     1
-keybcs2_bin    keybcs2 73              Yes     1
-keybcs2_general_ci     keybcs2 37      Yes     Yes     1
-koi8r_bin      koi8r   74              Yes     1
+koi8r_general_ci       koi8r   7       Yes             0
+koi8u_bin      koi8u   75                      0
+koi8u_general_ci       koi8u   22      Yes             0
 latin1_bin     latin1  47              Yes     1
 latin1_danish_ci       latin1  15              Yes     1
 latin1_general_ci      latin1  48              Yes     1
@@ -113,20 +113,20 @@
 latin2_czech_cs        latin2  2               Yes     4
 latin2_general_ci      latin2  9       Yes     Yes     1
 latin2_hungarian_ci    latin2  21              Yes     1
-latin5_bin     latin5  78              Yes     1
-latin5_turkish_ci      latin5  30      Yes     Yes     1
-latin7_bin     latin7  79              Yes     1
-latin7_estonian_cs     latin7  20              Yes     1
-latin7_general_ci      latin7  41      Yes     Yes     1
-latin7_general_cs      latin7  42              Yes     1
-macce_bin      macce   43              Yes     1
-macce_general_ci       macce   38      Yes     Yes     1
-macroman_bin   macroman        53              Yes     1
-macroman_general_ci    macroman        39      Yes     Yes     1
+latin5_bin     latin5  78                      0
+latin5_turkish_ci      latin5  30      Yes             0
+latin7_bin     latin7  79                      0
+latin7_estonian_cs     latin7  20                      0
+latin7_general_ci      latin7  41      Yes             0
+latin7_general_cs      latin7  42                      0
+macce_bin      macce   43                      0
+macce_general_ci       macce   38      Yes             0
+macroman_bin   macroman        53                      0
+macroman_general_ci    macroman        39      Yes             0
 sjis_bin       sjis    88              Yes     1
 sjis_japanese_ci       sjis    13      Yes     Yes     1
-swe7_bin       swe7    82              Yes     1
-swe7_swedish_ci        swe7    10      Yes     Yes     1
+swe7_bin       swe7    82                      0
+swe7_swedish_ci        swe7    10      Yes             0
 tis620_bin     tis620  89              Yes     1
 tis620_thai_ci tis620  18      Yes     Yes     4
 ucs2_bin       ucs2    90              Yes     1

mysqltest: Result content mismatch

How to repeat:
Run the "funcs1_ps" suite.  The failure only shows up on

  Generic Linux RPM (x86/x86_64/ia64)
  i5os powerpc (32/64bit)
  QNX
  SCO
  Solaris 10/x86
[29 Jul 2008 13:16] Joerg Bruehe
Similar in the 5.1.27 build,
specific to the "generic" RPMs.

It seems there is a configuration difference to other packages,
regarding the collations included.
[2 Feb 2009 18:38] Joerg Bruehe
Expectations came true:  Bug is also present in 5.0.77 (community).
[30 Mar 2009 15:34] 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:45] 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:41] 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:38] 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:21] 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:33] 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)