Hello,

yesterday, I tried upgrading my project to Django 1.3 from 1.2.4. One 
peculiar problem has arised: when I searched for users in the admin area, I 
suddenly had duplicated search results for some users. After comparing the 
queries with 1.2.4 it seems to me that a DISTINCT clause has been missing 
from the query. I could track the problem down to my UserProfile class: I 
used 'userprofile__groups__name' as search field in the my UserCustomAdmin 
(these are custom user groups, not the ones from contrib.auth), which lead 
to JOINs, which used to be DISTINCTed in 1.2.X, but in 1.3 are not anymore. 
Removing 'userprofile__groups__name' has solved the problem, however, there 
are no JOINs anymore either.

Can anyone pinpoint a change in 1.3 which leads to this behaviour? What 
should I do to prevent multiple results if I ever needed to be able to 
search in ManyToMany fields?

Thanks.

Nikolai.

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/django-users/-/VUpFb2tpcFFxOTRK.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.

Reply via email to