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

JSON_QUOTE() - return NULL on numbers

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.2.8
    • 10.2
    • JSON
    • None
    • Centos Linux 7.3

    Description

      I'm not sure if this is really a bug, but why JSON_QUOTE () returns NULL when the input parameter is not a string, but a number?

      My opinion in that case, is that the return value must be the same as input number.

      MariaDB [test]> SELECT JSON_QUOTE(90211);
      +-------------------+
      | JSON_QUOTE(90211) |
      +-------------------+
      | NULL              |
      +-------------------+
      1 row in set (0.00 sec)
      

      Attachments

        Activity

          People

            rucha174 Rucha Deodhar
            chaky Michal Hucik
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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