MySQL Bugs: #31556: Test failure: "select hex(ascii(a)) ... order by a" results in different order

Bug #31556	Test failure: "select hex(ascii(a)) ... order by a" results in different order
Submitted:	12 Oct 2007 8:21	Modified:	1 Nov 2007 12:55
Reporter:	Joerg Bruehe	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S3 (Non-critical)
Version:	5.0.50	OS:	Any
Assigned to:	Matthias Leich	CPU Architecture:	Any

Description:
Found in a custom build based on 5.0.50,

but this build was done only on Linux/x86 and Linux/x86_64 and only for the "enterprise" configuration,

so I cannot (yet) say whether it is general or specific by platform(s) or configuration(s).

This is the select statement:
 SELECT HEX(ASCII(a)) AS a_ascii, CHAR_LENGTH(a) AS a_len FROM test.t1 ORDER BY a, ORD(a);

On both platforms, I got the same difference:

@@ -737,7 +737,6 @@
 44     1
 64     1
 45     1
-60     1
 65     1
 46     1
 66     1
@@ -779,17 +778,18 @@
 78     1
 59     1
 79     1
-7E     1
 5A     1
 7A     1
-5D     1
 5B     1
 5C     1
+5D     1
 5E     1
 5F     1
+60     1
 7B     1
 7C     1
 7D     1
+7E     1
 7F     1
 80     1
 81     1                                                                                                                  
mysqltest: Result content mismatch

How to repeat:
Run the "funcs_2" suite.

I just notice I forgot to list the test case name -
it is all three in the "funcs_2" suite dealing with character sets:
   innodb_charset
   memory_charset
   myisam_charset
(NDB is not included in this configuration, so that test was not run.)

Short information after talking to Bar:
He thinks:
- The new order seems correct.
- The change in the tests were caused by this fix:
     http://bugs.mysql.com/bug.php?id=27562
     Bug#27562 ascii.xml invalid?

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/35756

ChangeSet@1.2538, 2007-10-17 17:32:02+02:00, mleich@four.local.lan +3 -0
  Fix for
  Bug#31556 Test failure: "select hex(ascii(a)) ... order by a" results in different order

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/35831

ChangeSet@1.2538, 2007-10-18 13:09:30+02:00, mleich@four.local.lan +4 -0
  Fix for
  Bug#31556 Test failure: "select hex(ascii(a)) ... order by a" results in different order

The upmerge to MySQL showed
Bug#31693 funcs_2: <engine>_charset tests fail,
          collation ..._czech_cs

The last comment is incomplete:
Upmerge to MySQL 5.2

Pushed to mysql-5.0-build, mysql-5.1-build and
mysql-5.2-build.
There is no documentation needed.

Pushed into 6.0.4-alpha

Pushed into 5.1.23-rc

Pushed into 5.0.52