id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
1878	API tests for sqlite3 broken, count(distinct(...)) does not work on sqlite3	mir@…	nobody	"sqlite3 appears not to understand select count(distinct(...)). Runtests shows:

{{{
Running tests with database 'sqlite3'

'many_to_many' module: API test raised an exception
===================================================
Code: 'Article.objects.filter(publications__title__startswith=""Science"").distinct().count()'
Line: 58
Exception:   File ""/home/mir/src/django/svn-trunk/tests/doctest.py"", line 1243, in __run
    compileflags, 1) in test.globs
  File ""<doctest many_to_many[25]>"", line 1, in ?
    Article.objects.filter(publications__title__startswith=""Science"").distinct().count()
  File ""/home/mir/src/django/active/django/db/models/query.py"", line 188, in count
    cursor.execute(""SELECT COUNT(DISTINCT(%s))"" % id_col + sql, params)
  File ""/home/mir/src/django/active/django/db/backends/sqlite3/base.py"", line 73, in execute
    return Database.Cursor.execute(self, query, params)
OperationalError: near ""DISTINCT"": syntax error


'many_to_one' module: API test raised an exception
==================================================
Code: ""Reporter.objects.filter(article__headline__startswith='This').distinct().count()""
Line: 183
Exception:   File ""/home/mir/src/django/svn-trunk/tests/doctest.py"", line 1243, in __run
    compileflags, 1) in test.globs
  File ""<doctest many_to_one[69]>"", line 1, in ?
    Reporter.objects.filter(article__headline__startswith='This').distinct().count()
  File ""/home/mir/src/django/active/django/db/models/query.py"", line 188, in count
    cursor.execute(""SELECT COUNT(DISTINCT(%s))"" % id_col + sql, params)
  File ""/home/mir/src/django/active/django/db/backends/sqlite3/base.py"", line 73, in execute
    return Database.Cursor.execute(self, query, params)
OperationalError: near ""DISTINCT"": syntax error
}}}

This probably got introduced by changeset 2902 / ticket #1530

I got into the habit to check tests after each merge with my patches ...
"	defect	closed	Database layer (models, ORM)	dev	major	wontfix		malcolm@… leftwing17@… brice.carpentier@…	Accepted	0	1	1	0	0	0