[phpBT-dev] CVS: phpbt/inc/db pgsql.php,1.20,1.21

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/inc/db
In directory sc8-pr-cvs1:/tmp/cvs-serv13087/inc/db

Modified Files:
	pgsql.php 
Log Message:
Fixes bug #650899 - Query cleanup

Index: pgsql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v
retrieving revision 1.20
retrieving revision 1.21
diff -u -r1.20 -r1.21
--- pgsql.php	30 Sep 2002 18:02:06 -0000	1.20
+++ pgsql.php	17 Dec 2002 13:26:07 -0000	1.21
@@ -146,7 +146,7 @@
 		'and b.component_id = component.component_id '.
 		'and b.project_id = project.project_id %s '.
 		'order by %s %s, bug_id asc',
-	'report-resbyeng-1' => 'select email as "Assigned To", '.
+	'report-resbyeng-1' => 'select u.email as "Assigned To", '.
 		'sum(case when resolution_id = 0 then 1 else 0 end) as "Open"',
 	'report-resbyeng-2' => "select resolution_name, ",
 	'report-resbyeng-3' => "', sum(case when resolution_id = '",
@@ -157,13 +157,13 @@
 		'left join '.TBL_AUTH_USER.' u on assigned_to = user_id %s '.
 		'group by assigned_to, u.email',
 	'join-where' => 'where',
-	'admin-list-components' => 'select c.component_id, component_name, '.
-		'c.created_date, active, count(bug_id) as bug_count '.
+	'admin-list-components' => 'select c.component_id, c.component_name, '.
+		'c.created_date, c.active, count(bug_id) as bug_count '.
 		'from '.TBL_COMPONENT.' c left join '.TBL_BUG.' b using(component_id) '.
 		'where c.project_id = %s '.
 		'group by c.component_id, c.component_name, c.created_date, c.active',
-	'admin-list-versions' => 'select v.version_id, version_name, '.
-		'v.created_date, active, count(bug_id) as bug_count '.
+	'admin-list-versions' => 'select v.version_id, v.version_name, '.
+		'v.created_date, v.active, count(bug_id) as bug_count '.
 		'from '.TBL_VERSION.' v left join '.TBL_BUG.' b using(version_id) '.
 		'where v.project_id = %s '.
 		'group by v.version_id, v.version_name, v.created_date, v.active',