[MDEV-26134] Embedding JSON from derived tables quotes the JSON, unlike from scalar subqueries Created: 2021-07-13 Updated: 2021-07-13 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | JSON, Server |
| Affects Version/s: | 10.5.11 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Lukas Eder | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
The following query wraps JSON from a derived table in more JSON:
This results in undesirable output:
It doesn't happen with scalar subqueries:
Or with the usual laborious workaround for such problems:
Both resulting in the expected output
For comparison, MySQL 8.0.22 doesn't behave this way. |
| Comments |
| Comment by Lukas Eder [ 2021-07-13 ] |
|
Related issue: |
| Comment by Sergei Golubchik [ 2021-07-13 ] |
|
may be add782a13e58 fixes it |