Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.5, 10.6, 10.11, 10.11.2, 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
Try this query:
select
|
json_arrayagg(json_array(ö)),
|
json_arrayagg(json_object(ö, ö)),
|
json_arrayagg(ö)
|
from (select 'ö' ö) ö;
|
It produces
|json_arrayagg(json_array(ö))|json_arrayagg(json_object(ö, ö))|json_arrayagg(ö)|
|
|----------------------------|--------------------------------|----------------|
|
|[["ö"]] |[{"ö": "ö"}] |["�"] |
|
So, when JSON is nested in JSON, then there's no encoding problem, but a string embedded directly into JSON_ARRAYAGG produces issues.
Attachments
Issue Links
- duplicates
-
MDEV-24784 JSON_ARRAYAGG charset issue
- Closed