Hi,
I was wondering if this is correct:
I am using an fetch limit for some queries, though I also need to make sure
I add the prefetch rules to refresh the data. I read in the documentation
that i should use DISJOINT_BY_ID_PREFETCH_SEMANTICS, so I did. Now when I
look at the queries I am a little bit surprised because I see the same id
occur many times. Shouldn't this be purged before building the query?
Example query would be:
SELECT t0.*
FROM djem_account t0
WHERE ( t0.id = 217 )
OR ( t0.id = 217 )
OR ( t0.id = 217 )
OR ( t0.id = 217 )
OR ( t0.id = 217 )
OR ( t0.id = 217 )
OR ( t0.id = 217 )
OR ( t0.id = 217 )
OR ( t0.id = 217 )
OR ( t0.id = 217 )
OR ( t0.id = 217 )
OR ( t0.id = 217 )
OR ( t0.id = 217 )
OR ( t0.id = 219 )
OR ( t0.id = 219 )
OR ( t0.id = 219 )
OR ( t0.id = 219 )
OR ( t0.id = 219 )
OR ( t0.id = 219 )
OR ( t0.id = 219 )
OR ( t0.id = 219 )
OR ( t0.id = 219 )
OR ( t0.id = 219 )
OR ( t0.id = 219 )
OR ( t0.id = 219 );
Best regards,
Mark Stobbe