Details
-
Bug
-
Status: Done
-
Low
-
Resolution: Fixed
-
8.0.x, Not 5.6.x, Not 5.7.x
-
None
Description
On 8.0, intermittently:
190307 9:02:37 [ 69%] main.percona_heap_blob w6 [ fail ]
Test ended at 2019-03-07 09:02:37
CURRENT_TEST: main.percona_heap_blob
--- /tmp/results/PS/mysql-test/r/percona_heap_blob.result 2019-03-07 10:36:43.000000000 +0300
+++ /tmp/results/PS/mysql-test/var/6/log/percona_heap_blob.reject 2019-03-07 12:02:36.749051908 +0300
@@ -749,9 +749,9 @@
select hex(a) from t1 order by a;
hex(a)
NULL
-6100
61
61
+6100
6161
62
select hex(concat(a,'\0')) as b from t1 order by concat(a,'\0');
This is an occurrence of upstream https://bugs.mysql.com/bug.php?id=93472. The issue is that the char(5) column being queried is in utf8mb4_0900_ai_ci collation, where the trailing spaces and \0 compare equal, making ordering non-determinstic. A binary collation should be used instead.
