[MDEV-12020] ctype tests are non-deterministic due to missing sorting Created: 2017-02-08  Updated: 2017-02-08  Resolved: 2017-02-08

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.2
Fix Version/s: 10.2.4

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: 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.


Generated at Thu Feb 08 07:54:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.