Searches on related fields (can) cause duplicate results

[sjamaan]

When using search for related fields that end in multiple records, binder may return the same record more than once, depending on circumstances.

The same issue also happens when using a Q() object in a permission filter that traverses a relation into a "many" side.

Example (untested yet):

• Add searches = ['animals__name__icontains'] to CaretakerView
• Set up a caretaker with multiple animals under his care
• Search for a substring that contains multiple animals
• Result has more than one caretaker record with the same id

[sjamaan]

My current workaround involves crafting a custom search() method which adds an Exists annotation and searches on that, instead.