Bug #40545 test funcs_1.charset_collation_1 fails on pushbuild2
Submitted: 6 Nov 2008 10:34 Modified: 10 Jul 2009 15:20
Reporter: Mattias Jonsson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:5.1+ OS:Any
Assigned to: Matthias Leich CPU Architecture:Any
Tags: pb2, test failure

[6 Nov 2008 10:34] Mattias Jonsson
Description:
funcs_1.charset_collation_1 fails on most platforms on pushbuild2.

Might be related to bug#36787

How to repeat:
Check the pushbuild2 reports (both 5.1 and 6.0)

funcs_1.charset_collation_1 [ fail ]

--- /export/home/pb2/test/sb_6-115679-1225893599.04/mysql-6.0.9-alpha-linux-x86_64-test/mysql-test/suite/funcs_1/r/charset_collation_1.result	2008-11-05 15:21:26.000000000 +0300
+++ /export/home/pb2/test/sb_6-115679-1225893599.04/mysql-6.0.9-alpha-linux-x86_64-test/mysql-test/suite/funcs_1/r/charset_collation_1.reject	2008-11-05 22:13:59.000000000 +0300
@@ -50,10 +50,10 @@
 FROM information_schema.collations
 ORDER BY collation_name;
 COLLATION_NAME	CHARACTER_SET_NAME	ID	IS_DEFAULT	IS_COMPILED	SORTLEN
-armscii8_bin	armscii8	64			0
-armscii8_general_ci	armscii8	32	Yes		0
-ascii_bin	ascii	65			0
-ascii_general_ci	ascii	11	Yes		0
+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
 big5_bin	big5	84		Yes	1
 big5_chinese_ci	big5	1	Yes	Yes	1
 binary	binary	63	Yes	Yes	1
@@ -62,26 +62,26 @@
 cp1250_czech_cs	cp1250	34		Yes	2
 cp1250_general_ci	cp1250	26	Yes	Yes	1
 cp1250_polish_ci	cp1250	99		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
+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
 cp932_bin	cp932	96		Yes	1
 cp932_japanese_ci	cp932	95	Yes	Yes	1
-dec8_bin	dec8	69			0
-dec8_swedish_ci	dec8	3	Yes		0
+dec8_bin	dec8	69		Yes	1
+dec8_swedish_ci	dec8	3	Yes	Yes	1
 eucjpms_bin	eucjpms	98		Yes	1
 eucjpms_japanese_ci	eucjpms	97	Yes	Yes	1
 euckr_bin	euckr	85		Yes	1
@@ -90,20 +90,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			0
-geostd8_general_ci	geostd8	92	Yes		0
-greek_bin	greek	70			0
-greek_general_ci	greek	25	Yes		0
-hebrew_bin	hebrew	71			0
-hebrew_general_ci	hebrew	16	Yes		0
-hp8_bin	hp8	72			0
-hp8_english_ci	hp8	6	Yes		0
-keybcs2_bin	keybcs2	73			0
-keybcs2_general_ci	keybcs2	37	Yes		0
-koi8r_bin	koi8r	74			0
-koi8r_general_ci	koi8r	7	Yes		0
-koi8u_bin	koi8u	75			0
-koi8u_general_ci	koi8u	22	Yes		0
+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	Yes	1
+koi8u_bin	koi8u	75		Yes	1
+koi8u_general_ci	koi8u	22	Yes	Yes	1
 latin1_bin	latin1	47		Yes	1
 latin1_danish_ci	latin1	15		Yes	1
 latin1_general_ci	latin1	48		Yes	1
@@ -117,20 +117,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			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
+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
 sjis_bin	sjis	88		Yes	1
 sjis_japanese_ci	sjis	13	Yes	Yes	1
-swe7_bin	swe7	82			0
-swe7_swedish_ci	swe7	10	Yes		0
+swe7_bin	swe7	82		Yes	1
+swe7_swedish_ci	swe7	10	Yes	Yes	1
 tis620_bin	tis620	89		Yes	1
 tis620_thai_ci	tis620	18	Yes	Yes	4
 ucs2_bin	ucs2	90		Yes	1

mysqltest: Result content mismatch

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

Suggested fix:
Fix the test?
[6 Nov 2008 14:29] Matthias Leich
I was able to reproduce the problem with an archive of
the build. The number of "compiled in" collations is
significant bigger than expected.
1. This problem is definitely no server bug.
2. It might be that the bigger amount of "compiled in"
   collations was not intended (very unlikely) but
   this is no serious problem like a loss of functionality .
3. The problem has to be fixed by adjustment of the
   funcs_1.charset_collation_* tests.
   Some warning:
   The adjustment cannot be done by overwriting the
   expected results of charset_collation_1 with the
   current results because charset_collation_1 passes
   on other build types like
      BUILD/compile-...-debug-max
      BUILD/compile-...-debug
      BUILD/compile-...-max
      BUILD/compile-...
   + testing within the source tree.
[30 Mar 2009 15:36] Matthias Leich
charset_collation_1 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 15:27] Matthias Leich
Changing the assignment to me, because my patch should fix
the problem.
[19 Jun 2009 17:39] 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:37] 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:20] Paul DuBois
Test case changes. No changelog entry needed.
[26 Aug 2009 13:45] 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)