On Mon, 2006-08-28 at 01:14 -0700, [EMAIL PROTECTED] wrote: > Hi Russ, > > Nice work! > > FYI I submitted a patch (#2490 [1] ) a while ago to get runtests.py to > produce an error if no DJANGO_SETTINGS_MODULE is in the env. Not sure > if this is something you want, but I've updated it to work post r3661 - > it does make it a little bit easier to work out how to run the tests! > > Next - I'm getting failures with an SQLite database on: > FAIL: Doctest: modeltests.many_to_many.models.__test__.API_TESTS > FAIL: Doctest: modeltests.many_to_one.models.__test__.API_TESTS > > Both of these look like they're failing due to SQLite not being able to > handle COUNT(DISTINCT(fieldname)).
Are you running an old SQLite version? My recollection is that SQLite introduced support for count(distinct(...)) about a year ago now. The main distribution I believe is affected are people running old Debian setups (maybe Debian testing is still affected, I don't know). There's an old thread about this on this list. In short, it's a little hard to support the older SQLite versions, because they would end up giving wrong answers for certain queries. We never really resolved it one way or the other, though, so a minimum version number isn't correctly documented. One SQLite oddity here is that SQLite does not support count(distinct(*)) -- you need to include a column name. Not sure if that is the problem you are seeing or not. In any case, we have been testing count(distinct(pk_field)) queries for a number of months now as part of the test suite, so if you could check a subversion checkout from before Russell committed his changes and see if the results have actually changed, that would be handy. When I was originally looking over these patches, I tested against SQLite, amongst other things, and saw no failures, so it would be interesting to know what is different on your system if it's something other than an older SQLite installation. Regards, Malcolm --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-developers -~----------~----~----~----~------~----~------~--~---
