Watch out for the "GROUP BY" clause in your SQL! It does not work the same as before. As Sergey said, check SET ENGINEBEHAVIOR.