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
9411	Test added in [9081] fails on MySQL	Karen Tracey	Malcolm Tredinnick	"[9081] added:

{{{
Make sure bump_prefix() (an internal Query method) doesn't (re-)break.
>>> query = Tag.objects.values_list('id').order_by().query
>>> query.bump_prefix()
>>> print query.as_sql()[0]
SELECT U0.""id"" FROM ""queries_tag"" U0
}}}

to regressionstest/queries/models.py but this fails on MySQL due to quoting differences:

{{{
======================================================================
FAIL: Doctest: regressiontests.queries.models.__test__.API_TESTS
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/home/kmt/django/trunk/django/test/_doctest.py"", line 2180, in runTest
    raise self.failureException(self.format_failure(new.getvalue()))
AssertionError: Failed doctest test for regressiontests.queries.models.__test__.API_TESTS
  File ""/home/kmt/django/trunk/tests/regressiontests/queries/models.py"", line unknown line number, in API_TESTS

----------------------------------------------------------------------
File ""/home/kmt/django/trunk/tests/regressiontests/queries/models.py"", line ?, in regressiontests.queries.models.__test__.API_TESTS
Failed example:
    print query.as_sql()[0]
Expected:
    SELECT U0.""id"" FROM ""queries_tag"" U0
Got:
    SELECT U0.`id` FROM `queries_tag` U0


----------------------------------------------------------------------
Ran 1 test in 1.251s

FAILED (failures=1)
}}}

Not sure how to fix it since I'm not sure how much of that output is significant.  Is it sufficient that no exception was raised (seemed to be what happened before the fix)?  Or do we have a general way of dealing with quoting differences in backends (like file path differences)?  "		closed	Uncategorized	1.0		fixed			Unreviewed	0	0	0	0	0	0