[MDEV-36570] select with json function - Jira

XML

Word

Printable

– please edit the field summary and components to reflect the bug
– i am not too familiar with the server internal

WITH A(a) AS (SELECT id FROM json_table('[1, 2, 3, 4, 5, 6, 7, 8, 9, 10]', '$[*]' COLUMNS (id int PATH '$')) T)

SELECT JSON_INSERT('{"id": 1}', '$.ids', (SELECT JSON_ARRAYAGG(a) FROM A));

*==> work as expected *

WITH A(a) AS (SELECT id FROM json_table('[1, 2, 3, 4, 5, 6, 7, 8, 9, 10]', '$[*]' COLUMNS (id int PATH '$')) T),

B(a) AS (SELECT JSON_INSERT('{"id": 1}', '$.ids', (SELECT JSON_ARRAYAGG(a) FROM A)))

select * from B;

==> does not show the same result

relates to

MDEV-26624 JSON in CTEs sometimes get broken

MDEV-31554 Cursor protocol cuts off the end of json body for some json functions

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.