Bug #86967 json_group_concat_ndb is unstable
Submitted: 6 Jul 2017 10:51 Modified: 7 Jul 2017 10:53
Reporter: Knut Anders Hatlen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: JSON Severity:S3 (Non-critical)
Version:8.0.3 OS:Any
Assigned to: CPU Architecture:Any

[6 Jul 2017 10:51] Knut Anders Hatlen
Description:
json.json_group_concat_ndb               w1 [ fail ]
        Test ended at 2017-07-05 17:36:12

CURRENT_TEST: json.json_group_concat_ndb
--- /export/home2/pb2/test/sb_4-24116437-1499268848.07/mysql-commercial-8.0.3-rc-linux-x86_64-ndbcluster/mysql-test/suite/json/r/json_group_concat_ndb.result	2017-07-05 17:38:40.000000000 +0300
+++ /dev/shm/mtr-18658/var-all-default/1/log/json_group_concat_ndb.reject	2017-07-05 18:36:12.243935945 +0300
@@ -49,14 +49,14 @@
 9
 select group_concat(c order by c) from t;
 group_concat(c order by c)
-,,	,
+,,	,
 ,,
,",\,a
 select char_length(group_concat(c)) from t;
 char_length(group_concat(c))
 17
 select json_quote(group_concat(c order by c)) from t;
 json_quote(group_concat(c order by c))
-"\u0010,\b,\t,\n,\f,\r,\",\\,a"
+"\b,\u0010,\t,\n,\f,\r,\",\\,a"
 select char_length(json_quote(group_concat(c))) from t;
 char_length(json_quote(group_concat(c)))
 31

mysqltest: Result content mismatch

safe_process[39429]: Child process: 39430, exit: 1

How to repeat:
Run the test. It occasionally fails.
[7 Jul 2017 10:53] Jon Stephens
Test case, fixed in MySQL 8.0.3. No changelog entry needed. Closed.