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

mysqli silently trims each json_arrayagg result to modulo 64KB

    XMLWordPrintable

Details

    • Unexpected results

    Description

      The reproducible query is simple with 2 bound variables/strings with more than 65336 bytes.

      The current output is:

      array(1) {
      		 
        ["agg"]=>
      		 
        string(16) "["xxxx","yxxxx"]"
      		 
      }
      		 
      bool(false)
      		 
      array(1) {
      		 
        ["agg"]=>
      		 
        string(16) "["xxxx","yxxxx"]"
      		 
      }
      		 
      bool(false)

      but I would expect:

      array(1) {
      		 
        ["agg"]=>
      		 
        string(131086) "["xxxx...","yxxxx..."]"
      		 
      }
      		 
      bool(true)
      		 
      array(1) {
      		 
        ["agg"]=>
      		 
        string(131086) "["xxxx...","yxxxx..."]"
      		 
      }
      		 
      bool(true)

      Please confirm and fix.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            mv Michael Voříšek
            Votes:
            0 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.