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

Using JSON_SET in the VIEW creation truncates the JSON data

    XMLWordPrintable

Details

    Description

      Hi,

      In the following test case, I adjust the order of the values in a JSON data, but the first view generates a truncated JSON:

      CREATE VIEW v_bad AS
      SELECT JSON_SET('{}', '$.k1', 'x', '$.k2', REPEAT('b', 40)) AS j;
       
      CREATE VIEW v_good AS
      SELECT JSON_SET('{}', '$.k2', REPEAT('b', 40), '$.k1', 'x') AS j;
       
      SELECT 'bad_view' AS case_name, LENGTH(j) AS len, JSON_VALID(j) AS is_valid, j FROM v_bad; -- bad_view	33	0	{"k1": "x", "k2": "bbbbbbbbbbbbbb
      SELECT 'good_view' AS case_name, LENGTH(j) AS len, JSON_VALID(j) AS is_valid, j FROM v_good; -- good_view	61	1	{"k2": "bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb", "k1": "x"}
      

      Attachments

        Issue Links

          Activity

            People

              rucha174 Rucha Deodhar
              ChiZhang Chi Zhang
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.