I understand what both of you say. I had to try this solution (even if I'm not sure of the results), because I don't know how to do with this issue.
So I turned the second argument to FALSE, and the results seems to be better (I can't see any duplicated lines on my grid result). There is the generated query : SELECT > a.* > FROM > ( > SELECT > v0_.LIBELLE AS LIBELLE0, > v0_.MNEMONIQUE AS MNEMONIQUE1, > v0_.ID_VARIABLE AS ID_VARIABLE2, > p1_.ID_PROFIL AS ID_PROFIL3 > FROM > VARIABLE v0_ > LEFT JOIN variable_profil v2_ ON v0_.ID_VARIABLE = v2_.ID_VARIABLE > LEFT JOIN PROFIL p1_ ON p1_.ID_PROFIL = v2_.ID_PROFIL > ORDER BY > v0_.LIBELLE ASC > ) a > WHERE > ROWNUM <= 100 I'm not sure that is a good thing to change this parameter value (because of possible duplication). But for now, it seems to be ok. So thank you Le jeudi 12 juin 2014 12:37:16 UTC+2, Jàπ (Jasper N. Brouwer) a écrit : > > You're doing a fetch join, so you better _not_ turn of those 2 queries the > paginator uses... > Like I said, you'll get inconsistent results. > > -- > Jasper N. Brouwer > (@jaspernbrouwer) > > > On 12 June 2014 at 12:12:50, [email protected] <javascript:> ( > [email protected] <javascript:>) wrote: > > Ok, I'll try to change the second argument of the Paginator. > > I'll post the result later. > > > > Thank you. > > > -- 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 http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
