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

GROUP_CONCAT shows 1 result having all null values when no result can be found

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 5.5.43-galera
    • N/A
    • OTHER
    • None
    • Debian

    Description

      Also issued at mysql bugs: http://bugs.mysql.com/bug.php?id=77222

      GROUP_CONCAT shows 1 result having all null values when no result can be found, instead of showing 0 results.

      Example: http://sqlfiddle.com/#!9/2b29e/1

      How to repeat:
      CREATE TABLE `test` (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `name` varchar(255) DEFAULT NULL,
      PRIMARY KEY (`id`)
      ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

      SELECT *, GROUP_CONCAT(name) FROM test

      Expected result:
      Record Count: 0

      Actual result:
      Record Count: 1
      id name GROUP_CONCAT(name)
      (null) (null) (null)

      Attachments

        Activity

          People

            Unassigned Unassigned
            rgeraads Randy Geraads
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.