Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
5.5.43-galera
-
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)