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

COLUMN_JSON() doesn't escape control characters in string values

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.15
    • 10.0.34, 10.1.31, 10.2.13, 10.3.5
    • Dynamic Columns
    • None
    • Darwin 13.4.0 Darwin Kernel Version 13.4.0: Sun Aug 17 19:50:11 PDT 2014; root:xnu-2422.115.4~1/RELEASE_X86_64 x86_64
    • 10.0.34

    Description

      According to RFC 4627 http://www.ietf.org/rfc/rfc4627.txt

      "All Unicode characters may be placed within the quotation marks except for the characters that must be escaped: quotation mark, reverse solidus, and the control characters (U+0000 through U+001F)."

      If you store a string that contains a control character in a dynamic column and fetch it back with COLUMN_JSON() then the control character is not escaped in the JSON encoded value returned.

      All the JSON decoders I have tried it with fail on such strings.

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12947 COLUMN_JSON does not properly encode newlines

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Oleksandr Byelkin made transition -
            Open In Progress
            		1087d 7h 57m 1
            Oleksandr Byelkin made transition -
            In Progress Stalled
            		7h 28m 1
            Oleksandr Byelkin made transition -
            Stalled In Review
            		22m 56s 1
            Sergei Golubchik made transition -
            In Review Stalled
            		4h 8m 1
            Oleksandr Byelkin made transition -
            Stalled In Progress
            		16h 7m 1
            Oleksandr Byelkin made transition -
            In Progress Closed
            		42s 1

            People

              sanja Oleksandr Byelkin
              thefsb Tom
              Votes:
              1 Vote for this issue
              Watchers:
              4 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.