#7570: test failure with sqlite3 version < 3.3.6, typically on Windows: ORDER BY
terms must not be non-integer constants
--------------------------------------------------------+-------------------
Reporter: Karen Tracey <[EMAIL PROTECTED]> | Owner: nobody
Status: new | Milestone:
Component: Database wrapper | Version: SVN
Resolution: | Keywords:
Stage: Accepted | Has_patch: 0
Needs_docs: 0 | Needs_tests: 0
Needs_better_patch: 0 |
--------------------------------------------------------+-------------------
Comment (by Richard Davies <[EMAIL PROTECTED]>):
With 1.0rc1 there are also two more similar failures in
regressiontests/extra_regress:
{{{
======================================================================
FAIL: Doctest: regressiontests.extra_regress.models.__test__.API_TESTS
----------------------------------------------------------------------
Traceback (most recent call last):
File "/home/elastic/django-dev/trunk/django/test/_doctest.py", line
2180, in runTest
raise self.failureException(self.format_failure(new.getvalue()))
AssertionError: Failed doctest test for
regressiontests.extra_regress.models.__test__.API_TESTS
File "/home/elastic/django-
dev/trunk/tests/regressiontests/extra_regress/models.py", line unknown
line number, in API_TESTS
----------------------------------------------------------------------
File "/home/elastic/django-
dev/trunk/tests/regressiontests/extra_regress/models.py", line ?, in
regressiontests.extra_regress.models.__test__.API_TESTS
Failed example:
User.objects.extra(select={'extra_field': 1},
order_by=['extra_field'])
Exception raised:
Traceback (most recent call last):
File "/home/elastic/django-dev/trunk/django/test/_doctest.py", line
1267, in __run
compileflags, 1) in test.globs
File "<doctest
regressiontests.extra_regress.models.__test__.API_TESTS[26]>", line 1, in
<module>
User.objects.extra(select={'extra_field': 1},
order_by=['extra_field'])
File "/home/elastic/django-dev/trunk/django/db/models/query.py",
line 144, in __repr__
return repr(list(self))
File "/home/elastic/django-dev/trunk/django/db/models/query.py",
line 156, in __len__
self._result_cache.extend(list(self._iter))
File "/home/elastic/django-dev/trunk/django/db/models/query.py",
line 269, in iterator
for row in self.query.results_iter():
File "/home/elastic/django-dev/trunk/django/db/models/sql/query.py",
line 206, in results_iter
for rows in self.execute_sql(MULTI):
File "/home/elastic/django-dev/trunk/django/db/models/sql/query.py",
line 1700, in execute_sql
cursor.execute(sql, params)
File "/home/elastic/django-
dev/trunk/django/db/backends/sqlite3/base.py", line 167, in execute
return Database.Cursor.execute(self, query, params)
OperationalError: ORDER BY terms must not be non-integer constants
----------------------------------------------------------------------
File "/home/elastic/django-
dev/trunk/tests/regressiontests/extra_regress/models.py", line ?, in
regressiontests.extra_regress.models.__test__.API_TESTS
Failed example:
User.objects.extra(select={'extra_field': 1},
order_by=['extra_field']).distinct()
Exception raised:
Traceback (most recent call last):
File "/home/elastic/django-dev/trunk/django/test/_doctest.py", line
1267, in __run
compileflags, 1) in test.globs
File "<doctest
regressiontests.extra_regress.models.__test__.API_TESTS[27]>", line 1, in
<module>
User.objects.extra(select={'extra_field': 1},
order_by=['extra_field']).distinct()
File "/home/elastic/django-dev/trunk/django/db/models/query.py",
line 144, in __repr__
return repr(list(self))
File "/home/elastic/django-dev/trunk/django/db/models/query.py",
line 156, in __len__
self._result_cache.extend(list(self._iter))
File "/home/elastic/django-dev/trunk/django/db/models/query.py",
line 269, in iterator
for row in self.query.results_iter():
File "/home/elastic/django-dev/trunk/django/db/models/sql/query.py",
line 206, in results_iter
for rows in self.execute_sql(MULTI):
File "/home/elastic/django-dev/trunk/django/db/models/sql/query.py",
line 1700, in execute_sql
cursor.execute(sql, params)
File "/home/elastic/django-
dev/trunk/django/db/backends/sqlite3/base.py", line 167, in execute
return Database.Cursor.execute(self, query, params)
OperationalError: ORDER BY terms must not be non-integer constants
}}}
My conclusion would also be that we should just close this ticket as
'wontfix' and document that SQLite 3.3.6 or newer is required.
--
Ticket URL: <http://code.djangoproject.com/ticket/7570#comment:10>
Django Code <http://code.djangoproject.com/>
The web framework for perfectionists with deadlines
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django updates" 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-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
