Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.9.8
-
None
-
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)
|