Bug #40618 funcs_1.charset_collation_3 fails, scripts and or results need maintenance

• Submitted: 10 Nov 2008 17:03
• Modified: 10 Jul 2009 15:21
• Reporter: Matthias Leich
• Status: Closed
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.1.30
• OS: Any
• Assigned to: Matthias Leich
• CPU Architecture: Any

[10 Nov 2008 17:03] Matthias Leich

Description:
MySQL-*5.1.30 builds, 5.1-community.log
Usual difference between current and expected results:
------------------------------------------------------
--- ... /r/charset_collation_3.result 2008-11-09 ...
+++ ... /r/charset_collation_3.reject 2008-11-09 ...
@@ -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                      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
....

It is very likely that this test fails also on an
actual MySQL  6.0.

This is neither the result of
- a server bug
nor
- caused by a build config modification which
  removes functionality (collations etc.)
The test just needs maintenance.

How to repeat:
Please have a look into the corresponding results
reported by the build team or download the binaries
and run charset_collation_3.

Suggested fix:
Please adjust scripts and/or expected results.
The merge 5.1-> 6.0 will most probably force to
fix also
Bug#40209 Test "charset_collation_3" not adapted
    to new UTF encodings in 6.0

[30 Mar 2009 15:37] 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:[e-mail]-20090707074938-ksah1ibn0vs92cem) (version source revid:[e-mail]-20090619152120-h73s7h6mfoijjbwm) (merge vers: 5.0.84) (pib:11)

[8 Jul 2009 13:30] Bugs System

Pushed into 5.1.37 (revid:[e-mail]-20090708131116-kyz8iotbum8w9yic) (version source revid:[e-mail]-20090619154429-vxyjl2wmdj4bnxl6) (merge vers: 5.1.36) (pib:11)

[9 Jul 2009 7:35] Bugs System

Pushed into 5.0.84 (revid:[e-mail]-20090707074938-ksah1ibn0vs92cem) (version source revid:[e-mail]-20090619152120-h73s7h6mfoijjbwm) (merge vers: 5.0.84) (pib:11)

[9 Jul 2009 7:36] Bugs System

Pushed into 5.1.37 (revid:[e-mail]-20090708131116-kyz8iotbum8w9yic) (version source revid:[e-mail]-20090619154429-vxyjl2wmdj4bnxl6) (merge vers: 5.1.36) (pib:11)

[10 Jul 2009 11:21] Bugs System

Pushed into 5.4.4-alpha (revid:[e-mail]-20090710111017-bnh2cau84ug1hvei) (version source revid:[e-mail]-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:[e-mail]-20090826132541-yablppc59e3yb54l) (version source revid:[e-mail]-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:[e-mail]-20090826105955-bkj027t47gfbamnc) (version source revid:[e-mail]-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:[e-mail]-20090825194404-37rtosk049t9koc4) (version source revid:[e-mail]-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:[e-mail]-20090827163030-6o3kk6r2oua159hr) (version source revid:[e-mail]-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)