find({…, "group": "participants"}) returns some participants twice #2807

New Issue

Open

opened 2015-06-10 16:40:30 +00:00 by wjt · 0 comments

wjt commented

2015-06-10 16:40:30 +00:00

In the UI:

Make Year the first filter column
Select some year
Look at the list of participants: one would expect participants to appear at most once in that list, but some appear twice (but never more).

I took a look at the network traffic, and find({...conditions=[{year == 1952}], sort: [{key: items, operator: -}], group: participants is returning duplicates, with different counts for each.

I thought it might be something to do with fetching the list in two batches: [0, 100] and [100, 175] but the duplicates are returned within the same batch. Varying the batch size makes no difference, I've tried counting across [i+k]i, for k in [1, 10, 25, 100, 1000] for i in xrange(0, n, k) – the result is the same for all k.

The search results are the same when I select one of the duplicate participants, regardless of which one I pick, and the number of scenes returned is the sum of the two entries for them: one entity shows up with 21 and 17 scenes in the filter, and for either one I get back 38 scenes.

In the UI: * Make Year the first filter column * Select some year * Look at the list of participants: one would expect participants to appear at most once in that list, but some appear twice (but never more). I took a look at the network traffic, and `find({...conditions=[{year == 1952}], sort: [{key: items, operator: -}], group: participants` is returning duplicates, with different counts for each. I thought it might be something to do with fetching the list in two batches: [0, 100] and [100, 175] but the duplicates are returned within the same batch. Varying the batch size makes no difference, I've tried counting across `[i+k]i, for k in [1, 10, 25, 100, 1000] for i in xrange(0, n, k)` – the result is the same for all k. The search results are the same when I select one of the duplicate participants, regardless of which one I pick, and the number of scenes returned is the sum of the two entries for them: one entity shows up with 21 and 17 scenes in the filter, and for either one I get back 38 scenes.