Author: gjm
Date: Fri Apr 5 17:22:18 2013
New Revision: 1465051
URL: http://svn.apache.org/r1465051
Log:
fix a missing alias for subquery appearing in dashboard widgets - towards #498
Modified:
bloodhound/trunk/bloodhound_multiproduct/multiproduct/ticket/query.py
Modified: bloodhound/trunk/bloodhound_multiproduct/multiproduct/ticket/query.py
URL:
http://svn.apache.org/viewvc/bloodhound/trunk/bloodhound_multiproduct/multiproduct/ticket/query.py?rev=1465051&r1=1465050&r2=1465051&view=diff
==============================================================================
--- bloodhound/trunk/bloodhound_multiproduct/multiproduct/ticket/query.py
(original)
+++ bloodhound/trunk/bloodhound_multiproduct/multiproduct/ticket/query.py Fri
Apr 5 17:22:18 2013
@@ -86,7 +86,7 @@ class ProductQuery(Query):
self.num_items = 0
sql, args = self.get_sql(req, cached_ids, authname, tzinfo, locale)
if sql.startswith('SELECT ') and not sql.startswith('SELECT
DISTINCT '):
- sql = 'SELECT DISTINCT * FROM (' + sql + ')'
+ sql = 'SELECT DISTINCT * FROM (' + sql + ') AS subquery'
self.num_items = self._count(sql, args)
if self.num_items <= self.max:
