You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@bloodhound.apache.org by gj...@apache.org on 2013/04/05 19:22:19 UTC

svn commit: r1465051 - /bloodhound/trunk/bloodhound_multiproduct/multiproduct/ticket/query.py

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: