cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Stobbe <markstobb...@gmail.com>
Subject Disjoint by id
Date Mon, 14 Nov 2016 15:02:51 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message