Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.2(EOL)
-
None
Description
$ perl ./mtr main.ctype_utf8 --mysqld=--log-bin --mysqld=--binlog-format=row
|
|
|
CURRENT_TEST: main.ctype_utf8
|
--- /data/bld/10.2/mysql-test/r/ctype_utf8.result 2016-12-29 16:54:17.000000000 +0200
|
+++ /data/bld/10.2/mysql-test/r/ctype_utf8.reject 2017-02-08 02:26:51.523197917 +0200
|
@@ -10496,8 +10496,8 @@
|
Warning 1638 Non-ASCII separator arguments are not fully supported
|
SELECT c1 FROM t1;
|
c1
|
-b
|
c
|
+b
|
DROP TABLE t1;
|
$ perl ./mtr main.ctype_utf8mb4 --mysqld=--log-bin --mysqld=--binlog-format=row
|
|
|
CURRENT_TEST: main.ctype_utf8mb4
|
--- /data/bld/10.2/mysql-test/r/ctype_utf8mb4.result 2016-12-29 16:54:17.000000000 +0200
|
+++ /data/bld/10.2/mysql-test/r/ctype_utf8mb4.reject 2017-02-08 02:28:21.503197480 +0200
|
@@ -2334,8 +2334,8 @@
|
insert into t1 values (0xF2BFBFBF);
|
select hex(utf8mb4) from t1;
|
hex(utf8mb4)
|
-F2808080
|
F2BFBFBF
|
+F2808080
|
delete from t1;
|
Testing [F4][80..8F][80..BF][80..BF]
|
insert into t1 values (0xF4808080);
|
@@ -2345,9 +2345,9 @@
|
Warning 1366 Incorrect string value: '\xF4\x90\x80\x80' for column 'utf8mb4' at row 1
|
select hex(utf8mb4) from t1;
|
hex(utf8mb4)
|
-F4808080
|
-F48F8080
|
3F
|
+F48F8080
|
+F4808080
|
drop table t1;
|
#
|
# Check strnxfrm() with odd length
|
I'm not sure why SELECT started returning rows in a different order with row binlog in 10.2 – it does not seem to happen in earlier versions – but there is no sorting for the queries, so no guarantee anyway.