Bug #2971 GROUP_CONCAT() - need to force column as string
Submitted: 26 Feb 2004 6:00 Modified: 29 Jun 2004 13:03
Reporter: Eric Jacolin Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.1a OS:Windows (Windows 2000)
Assigned to: Assigned Account CPU Architecture:Any

[26 Feb 2004 6:00] Eric Jacolin 
Description:
While performing a GROUP_CONCAT( A.col ) on a joined table A, I got a NULL result (although I the result set is not empty)

So I forced col as a string, and it worked allright:
GROUP_CONCAT( CONCAT( A.col ) )

Is it a bug or an undocumented feature?

How to repeat:
()
[26 Feb 2004 8:57] Dean Ellis 
It may be a bug that has already been corrected in 4.1.2.  We need a small test case with the SQL to create/populate/query the tables which demonstrates this behavior.
[29 Jun 2004 13:03] Sergei Golubchik 
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.