[MDEV-11470] JSON_KEYS accepts arguments in invalid format - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2(EOL)
Fix Version/s: 10.2.3
Component/s: JSON
Labels:
- json-10.2

Description

Compare:

MariaDB 10.2
MariaDB [test]> SELECT JSON_KEYS('foo');
+------------------+
\| JSON_KEYS('foo') \|
+------------------+
\| NULL \|
+------------------+
1 row in set (0.00 sec)

MySQL 5.7
MySQL [test]> SELECT JSON_KEYS('foo');
ERROR 3141 (22032): Invalid JSON text in argument 1 to function json_keys: "Invalid value." at position 1.

Attachments

Issue Links

relates to

MDEV-9143 JSON_xxx functions

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2016-12-02 18:11

Elena Stepanova made changes - 2016-12-02 18:11

Field	Original Value	New Value
Link		This issue relates to TODO-873 [ TODO-873 ]

Elena Stepanova made changes - 2016-12-02 18:11

Link

This issue relates to ~~MDEV-9143~~ [ ~~MDEV-9143~~ ]

Alexey Botchkov made changes - 2016-12-13 08:58

Status

Open [ 1 ]

In Progress [ 3 ]

Alexey Botchkov added a comment - 2016-12-13 08:58

http://lists.askmonty.org/pipermail/commits/2016-December/010270.html

Alexey Botchkov added a comment - 2016-12-13 08:58 http://lists.askmonty.org/pipermail/commits/2016-December/010270.html

Alexey Botchkov made changes - 2016-12-13 08:58

Fix Version/s		10.2.3 [ 22115 ]
Fix Version/s	10.2 [ 14601 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Ian Gilfillan added a comment - 2017-01-23 20:52

Similar to ~~MDEV-11571~~, this one also appears not to have been fixed in 10.2.3, although the commit date is earlier. Will leave open to confirm whether it's fixed in 10.2.4.

Ian Gilfillan added a comment - 2017-01-23 20:52 Similar to MDEV-11571 , this one also appears not to have been fixed in 10.2.3, although the commit date is earlier. Will leave open to confirm whether it's fixed in 10.2.4.

Ian Gilfillan made changes - 2017-01-23 20:52

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Ian Gilfillan added a comment - 2017-01-23 21:09

Apologies, this was due to not having strict mode on, the warning does appear as expected.

SHOW WARNINGS;

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

| Level   | Code | Message                                                                       |

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

| Warning | 4038 | Syntax error in JSON text in argument 1 to function 'json_keys' at position 1 |

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

Safe to re-close, unfortunately I can't do so.

Ian Gilfillan added a comment - 2017-01-23 21:09 Apologies, this was due to not having strict mode on, the warning does appear as expected. SHOW WARNINGS; +---------+------+-------------------------------------------------------------------------------+ | Level | Code | Message | +---------+------+-------------------------------------------------------------------------------+ | Warning | 4038 | Syntax error in JSON text in argument 1 to function 'json_keys' at position 1 | +---------+------+-------------------------------------------------------------------------------+ Safe to re-close, unfortunately I can't do so.

Elena Stepanova made changes - 2017-01-24 17:00

Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:43

Workflow

MariaDB v3 [ 78609 ]

MariaDB v4 [ 151311 ]

People

Assignee:: Alexey Botchkov

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2016-12-02 18:11

Updated:: 2017-01-24 17:00

Resolved:: 2017-01-24 17:00

Git Integration

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

MariaDB Server