Fix Version/s: None
bulk_id_idx is just a copy of bulk_id because SASI does not work on partition key component at all for some reason.
Then i insert 1 million rows with the same bulk_id and different recipient. Then
Ok, it's fine here. Now let's query by SASI:
Hmm, very strange count - 10101 extra rows.
Ok, i've dumped the query result into a text file:
Here we have 200 extra rows for some reason.
Let's check if these are duplicates:
Yep, looks like.
Recreating index does not help. If i issue the very same query (against partition key bulk_id, not bulk_id_idx) - i get correct results.