[MDEV-13138] JSON_OBJECT returns null with strings containing backticks Created: 2017-06-21  Updated: 2017-09-12  Resolved: 2017-09-12

Status: Closed
Project: MariaDB Server
Component/s: JSON
Affects Version/s: 10.2.6, 10.2
Fix Version/s: 10.2.9

Type: Bug Priority: Major
Reporter: Guido Cella Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: json
Environment:

Ubuntu 16.04 and Debian 8


 Description   

JSON_OBJECT seems to return NULL when one of its arguments is a string containing one or more backticks. This can be reproduced with:

SELECT JSON_OBJECT('foo', '`')

or

SELECT JSON_OBJECT("foo", "bar`bar")

or

SELECT JSON_OBJECT('`', 'foo')



 Comments   
Comment by Elena Stepanova [ 2017-06-25 ]

For all examples above MySQL 5.7 returns a JSON object.

Generated at Thu Feb 08 08:03:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.