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

Reply via email to