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

JSON_VALID fail to validate integer zero in scientific notation

    XMLWordPrintable

Details

    Description

      query result expected
      select JSON_VALID(' {"number": 1E-4}

      ');

      		 1 1
      select JSON_VALID(' {"number": 0E-4}

      ');

      		 0 1
      select JSON_VALID(' {"number": 0.0}

      ');

      		 1 1

      0E-4 is a valid number and should be validated

      All other json validators tested accept zero in scientific notation.

      Attachments

        Activity

          People

            rucha174 Rucha Deodhar
            marcoben73 Marco Benuzzi
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.