Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11470

JSON_KEYS accepts arguments in invalid format

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.2(EOL)
    • 10.2.3
    • JSON

    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

          Task - A task that needs to be done. MDEV-9143 JSON_xxx functions

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            holyfoot Alexey Botchkov added a comment -

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

            holyfoot Alexey Botchkov added a comment - http://lists.askmonty.org/pipermail/commits/2016-December/010270.html
            greenman Ian Gilfillan added a comment -

            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.

            greenman Ian Gilfillan added a comment - 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.
            greenman Ian Gilfillan added a comment -

            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.

            greenman Ian Gilfillan added a comment - 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.

            People

              holyfoot Alexey Botchkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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