Hi, On Fri, Dec 30, 2016 at 11:33 AM, Jf <[email protected]> wrote:
> Hello > > Since mysql 5.7.5 group by have change > > https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html > > If I made this query > > $qb = $this->createQueryBuilder('d'); > $qb->select('ANY_VALUE(d.id), d.nom, count(d.nom) as lignes'); > $qb->groupBy('d.nom'); > $qb->orderBy('d.nom'); > > I have a error > > Expression #1 of SELECT list is not in GROUP BY clause and contains > nonaggregated column 'sepultures.d0_.id' which is not functionally > dependent on columns in GROUP BY clause; this is incompatible with > sql_mode=only_full_group_by > > As explain in mysql doc, this problem can resolve with any_value like this > > $qb = $this->createQueryBuilder('d'); > $qb->select('ANY_VALUE(d.id), d.nom, count(d.nom) as lignes'); > $qb->groupBy('d.nom'); > $qb->orderBy('d.nom'); > > But doctrine don't recognize this function > > [2/2] QueryException: [Syntax Error] line 0, col 7: Error: Expected known > function, got 'ANY_VALUE' > > How can I resolve it ? > > Thank > I don't see any difference between the two example queries that you posted. Marco Pivetta http://twitter.com/Ocramius http://ocramius.github.com/ -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
