The problem is not duplicate results, but missing results: When you paginate with 10 items per page, you might see only 8 items on page 1, even though there are 3 more pages (for example).
-- Jasper N. Brouwer (@jaspernbrouwer) On 12 June 2014 at 13:11:48, [email protected] ([email protected]) wrote: > 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 -- 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.
