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
815	[patch] select keyword to lookup_kwargs are being quoted incorrectly in query	rezzrovv	Adrian Holovaty	"Here is the issue:



{{{

@@ -1466,7 +1519,7 @@

     # Add any additional SELECTs passed in via kwargs.
     if kwargs.get('select'):
-        select.extend(['(%s) AS %s' % (s[1], s[0]) for s in kwargs['select']])
+        select.extend(['(%s) AS %s' % (db.db.quote_name(s[1]), db.db.quote_name(s[0])) for s in kwargs['select']])
}}}
If you have:
select={
        'choice_count': 'SELECT COUNT(*) FROM choices WHERE poll_id = polls.id'
    }
as described in the tutorial then you will get:
select somecol, (""SELECT COUNT(*) FROM choices WHERE poll_id = polls.id"") as ""choice_count"") from ...
versus
select somecol, (SELECT COUNT(*) FROM choices WHERE poll_id = polls.id) as ""choice_count"") from ...
as it should be.

Simply reverting this one line back works but not sure why it was changed in the first place.
"	defect	closed	Core (Other)		major	fixed			Unreviewed	1	0	0	0	0	0