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

JSON_OBJECTAGG silently drops rows with NULL keys

    XMLWordPrintable

Details

    Description

      DROP DATABASE IF EXISTS r4;
      CREATE DATABASE r4;
      USE r4;
      CREATE TABLE t(id INT AUTO_INCREMENT PRIMARY KEY, k VARCHAR(10), v INT);
      INSERT INTO t(k, v) VALUES ('a',1),('b',2),('a',3),('a',4),('c',NULL),(NULL,5),('b',NULL);
      SELECT JSON_OBJECTAGG(k, v) FROM t WHERE id IN (1,3);
      – MDB:

      {"a":1, "a":3}

      (invalid) MY:

      {"a": 3}

      SELECT JSON_VALID(JSON_OBJECTAGG(k, v)) FROM t WHERE id IN (1,3); – MDB: 1

      [M33] JSON_OBJECTAGG silently drops NULL-key rows
      SELECT JSON_OBJECTAGG(k, v) FROM t WHERE id IN (5,6);
      – MDB:

      {"c":null}

      (the NULL-key row is lost) MY: ERROR 3158
      SELECT JSON_OBJECTAGG(NULL, 1); – MDB: NULL MY: ERROR 3158

      Attachments

        Activity

          People

            rucha174 Rucha Deodhar
            chunlingqin chunlingqin
            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.