Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0.3, 5.5.31, 5.1.67, 5.2.14, 5.3.12
-
Debian GNU/Linux 7.1 (wheezy)
Description
Every query using a GROUP_CONCAT is showing an empty resultset with no NULL values on the column it should concatenate.
A simple "select studentId, group_concat(grades) from studentGrades where sutdentId=1" is giving a wrong output with the above description.
This is strange, the behavior on the server side seems to be like that in all versions down to at least 5.1, both MariaDB and MySQL.
It could however happen that the bad value somehow crept in with the upgrade or afterwards.
I'll check upgrade on Wheezy to make sure it doesn't come with the package. Meanwhile, can you check your config files and see where exactly the value is set? Also, are you the only one who has access to the files, can it be that somebody else modified it recently?