Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.9.8
-
None
-
OpenBSD 7.5 (GENERIC.MP) #82: Wed Mar 20 15:48:40 MDT 2024
Description
In this example, JSON_ARRAYAGG changes Unicode character 0xC2A0 (non-breaking space) to 0xA0:
MariaDB [t]> CREATE TABLE `t1` (`a` text);
|
Query OK, 0 rows affected (0.001 sec)
|
|
|
MariaDB [t]> INSERT INTO `t1` (`a`) VALUES (UNHEX('58C2A059')); -- X Y
|
Query OK, 1 row affected (0.000 sec)
|
|
|
MariaDB [t]> SELECT HEX(`a`) FROM `t1`;
|
+----------+
|
| HEX(`a`) |
|
+----------+
|
| 58C2A059 |
|
+----------+
|
1 row in set (0.000 sec)
|
|
|
MariaDB [t]> SELECT `a` FROM `t1`;
|
+------+
|
| a |
|
+------+
|
| X Y |
|
+------+
|
1 row in set (0.000 sec)
|
|
|
MariaDB [t]> SELECT HEX(JSON_ARRAY(`a`)) FROM `t1`;
|
+----------------------+
|
| HEX(JSON_ARRAY(`a`)) |
|
+----------------------+
|
| 5B2258C2A059225D |
|
+----------------------+
|
1 row in set (0.000 sec)
|
|
|
MariaDB [t]> SELECT JSON_ARRAY(`a`) FROM `t1`;
|
+-----------------+
|
| JSON_ARRAY(`a`) |
|
+-----------------+
|
| ["X Y"] |
|
+-----------------+
|
1 row in set (0.000 sec)
|
|
|
MariaDB [t]> SELECT HEX(JSON_ARRAYAGG(`a`)) FROM `t1`;
|
+-------------------------+
|
| HEX(JSON_ARRAYAGG(`a`)) |
|
+-------------------------+
|
| 5B2258A059225D |
|
+-------------------------+
|
1 row in set (0.000 sec)
|
|
|
MariaDB [t]> SELECT JSON_ARRAYAGG(`a`) FROM `t1`;
|
+--------------------+
|
| JSON_ARRAYAGG(`a`) |
|
+--------------------+
|
| ["X?Y"] |
|
+--------------------+
|
1 row in set (0.000 sec)
|
I'm not seeing this on 10.5, 10.6, 10.11 (below), 11.4 https://sqlize.online/sql/mariadb114/10c1f8e4ab2be588741941f1a3393ac8/ or very latest ( 11.8.0 beta)
MariaDB [test]> SELECT HEX(JSON_ARRAYAGG(`a`)) FROM `t1`;+-------------------------+| HEX(JSON_ARRAYAGG(`a`)) |+-------------------------+| 5B2258C2A059225D |+-------------------------+1 row in set (0.003 sec)MariaDB [test]> SELECT JSON_ARRAYAGG(`a`) FROM `t1`;+--------------------+| JSON_ARRAYAGG(`a`) |+--------------------+| ["X Y"] |+--------------------+1 row in set (0.002 sec)MariaDB [test]> \s--------------client/mariadb Ver 15.1 Distrib 10.11.11-MariaDB, for Linux (x86_64) using EditLine wrapperConnection id: 3Current database: testCurrent user: dan@localhostSSL: Not in useCurrent pager: stdoutUsing outfile: ''Using delimiter: ;Server: MariaDBServer version: 10.11.11-MariaDB Source distributionProtocol version: 10Connection: Localhost via UNIX socketServer characterset: latin1Db characterset: latin1Client characterset: utf8mb3Conn. characterset: utf8mb3So I'm assuming its been fixed in our maintained versions. If there's a charset/aggregation setting having an effect please reopen this.