admin: sort by client faults behaves strange

[ThomasWaldmann]

it is partially sorted (like "rather big at the top, rather small at the bottom"), but not completely sorted.

why? sqlite issue? django issue? it worked a while ago, but now does not any more.

[ThomasWaldmann]

sorting still behaves strange, the changeset did not fix the issue described in first post (I upgraded to django 1.8.x and other stuff as mentioned in requirements.d/all.txt).

[ThomasWaldmann]

Still happens with latest Django 1.8.14.

A simple query with ordering on that database works though:

In [7]: Host.objects.order_by('-client_faults').values_list('client_faults', flat=True)
Out[7]: [20, 19, 11, 10, 10, 10, 10, 10, 10, 9, 8, 6, 5, 5, 4, 4, 3, 3, 3, 3, '...(remaining elements truncated)...']

[ThomasWaldmann]

So, the suspicion is that there is either a bug in Django's "admin" or that the (sqlite) database is maybe getting confused by the query the admin is issuing (which might be more complex than the one I used above).

[ThomasWaldmann]

It currently works ok (Django 1.11), so I am closing this.
It's likely not a bug in nsupdate.info anyway.