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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.15
    • Fix Version/s: 10.0.34, 10.1.31, 10.2.13, 10.3.5
    • Component/s: Dynamic Columns
    • Labels:
      None
    • Environment:
      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
    • Sprint:
      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

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              thefsb Tom
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: