[MDEV-21902] Nested JSON_ARRAYAGG in JSON_OBJECT should not get escaped Created: 2020-03-10 Updated: 2022-01-19 Resolved: 2020-06-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | JSON, Server |
| Affects Version/s: | 10.5.1 |
| Fix Version/s: | 10.5.4 |
| Type: | Bug | Priority: | Major |
| Reporter: | Lukas Eder | Assignee: | Alexey Botchkov |
| Resolution: | Fixed | Votes: | 1 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||
| Description |
|
When running this query:
I'm getting this content (with the JSON_ARRAYAGG content being embedded in a string).
I'm expecting this instead:
I'm getting the expected result in MySQL or in Oracle. In the case of Oracle, use this syntax for comparison:
|
| Comments |
| Comment by Alexey Botchkov [ 2020-06-04 ] |
|
https://github.com/MariaDB/server/commit/2fcff310d024cc2201586c568391ba8b039f0bf3 |