Search code examples
mysqlinner-joinmysql-error-1064group-concat

Mysql 5.6.12 Group_concat with Inner Join Issue

Earlier we used to use Mysql Version 5.5.27 and with the following query

 SELECT S.StudentId, 
        SED.StudentEnrollmentDetailsId,
        FirstName, MiddleName, LastName, Address, PermanentAddress,
        GROUP_CONCAT(B.BatchName ORDER BY B.BatchId,B.IsVirtualBatch DESC) AS AllBatch  
 FROM Student S 
 INNER JOIN StudentEnrollmentDetails SED ON SED.StudentId = S.StudentId
 INNER JOIN StudentBatchTxn SBT ON SBT.StudentId = S.StudentId  
 WHERE SED.StudentId = ?
 AND SED.StudentEnrollmentDetailsId = ? AND S.CompanyId = ?

This query use to run properly whether student is present in StudentBatchTxn or not.

But now we have upgraded to mysql 5.6.12. Same query is returning rows with all columns as null.

Please help?

Solution

  • The below link should be helpful

    http://dev.mysql.com/doc/refman/5.6/en/bugs.html