[MDEV-30412] JSON_OBJECTAGG doesn't escape double quote in key - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.9.3, 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
Fix Version/s: 10.11.3, 11.0.1, 10.5.20, 10.6.13, 10.8.8, 10.9.6, 10.10.4
Component/s: JSON
Labels:
None
Environment:
OpenBSD 7.2

Description

MariaDB [(none)]> SELECT JSON_OBJECT('"', 1), JSON_OBJECTAGG('"', 1);

+---------------------+------------------------+

| JSON_OBJECT('"', 1) | JSON_OBJECTAGG('"', 1) |

+---------------------+------------------------+

| {"\"": 1}           | {""":1}                |

+---------------------+------------------------+

1 row in set (0.000 sec)

works correctly in MySQL 5.6

Attachments

Issue Links

relates to

MDEV-16620 Add support for JSON_ARRAYAGG and JSON_OBJECTAGG

Closed

Activity

Ascending order - Click to sort in descending order

Weijun Huang added a comment - 2023-02-12 16:06 - edited

This bug also happens in MasOS.

MariaDB Version 10.5.16-MariaDB-debug

 - SSL connections supported

 - binaries are debug compiled

 - binaries built with wsrep patch

Collecting tests...

Installing system database...

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT

--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019

SELECT JSON_OBJECT('"', 1), JSON_OBJECTAGG('"', 1);

JSON_OBJECT('"', 1)     JSON_OBJECTAGG('"', 1)

{"\"": 1}       {""":1}

main.json_test                           [ pass ]

--------------------------------------------------------------------------

The servers were restarted 0 times

Spent 0.000 of 7 seconds executing testcases

Completed: All 1 tests were successful.

Weijun Huang added a comment - 2023-02-12 16:06 - edited This bug also happens in MasOS. MariaDB Version 10.5 . 16 -MariaDB-debug - SSL connections supported - binaries are debug compiled - binaries built with wsrep patch Collecting tests... Installing system database... ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[ 1 ] Using MTR_BUILD_THREAD 300 , with reserved ports 16000 .. 16019 SELECT JSON_OBJECT( '"' , 1 ), JSON_OBJECTAGG( '"' , 1 ); JSON_OBJECT( '"' , 1 ) JSON_OBJECTAGG( '"' , 1 ) { "\"" : 1 } { "" ": 1 } main.json_test [ pass ] -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 7 seconds executing testcases Completed: All 1 tests were successful.

Daniel Black added a comment - 2023-02-14 01:03

Thanks to Weijun / Alex Huang

Daniel Black added a comment - 2023-02-14 01:03 Thanks to Weijun / Alex Huang

People

Assignee:: Daniel Black

Reporter:: Rogers

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2023-01-15 03:27

Updated:: 2023-02-14 01:03

Resolved:: 2023-02-14 01:03

Git Integration

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

MariaDB Server