|
From: Benjamin C. <bc...@us...> - 2002-09-13 19:33:21
|
Update of /cvsroot/phpbt/phpbt/inc/db In directory usw-pr-cvs1:/tmp/cvs-serv9701/inc/db Modified Files: mysql.php oci8.php pgsql.php Log Message: Trying to fix the latest oracle problem with the bug query. Index: mysql.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v retrieving revision 1.13 retrieving revision 1.14 diff -u -r1.13 -r1.14 --- mysql.php 3 Sep 2002 19:44:56 -0000 1.13 +++ mysql.php 13 Sep 2002 19:33:17 -0000 1.14 @@ -129,7 +129,8 @@ 'query-list-bugs-count' => 'select count(*) '. 'from '.TBL_BUG.' b '. 'left join '.TBL_AUTH_USER.' owner on b.assigned_to = owner.user_id '. - 'left join '.TBL_AUTH_USER.' reporter on b.created_by = reporter.user_id where ', + 'left join '.TBL_AUTH_USER.' reporter on b.created_by = reporter.user_id ', + 'query-list-bugs-count-join' => 'where ', 'query-list-bugs' => 'select %s '. 'from '.TBL_BUG.' b '. 'left join '.TBL_AUTH_USER.' owner on b.assigned_to = owner.user_id '. Index: oci8.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v retrieving revision 1.11 retrieving revision 1.12 diff -u -r1.11 -r1.12 --- oci8.php 6 Sep 2002 17:42:04 -0000 1.11 +++ oci8.php 13 Sep 2002 19:33:17 -0000 1.12 @@ -132,7 +132,8 @@ 'query-list-bugs-count' => 'select count(*) '. 'from '.TBL_BUG.' b, '.TBL_AUTH_USER.' owner, '.TBL_AUTH_USER.' reporter '. 'where b.assigned_to = owner.user_id(+) '. - 'and b.created_by = reporter.user_id(+) and ', + 'and b.created_by = reporter.user_id(+) ', + 'query-list-bugs-count-join' => 'and ', 'query-list-bugs' => 'select %s '. 'from '.TBL_BUG.' b, '.TBL_AUTH_USER.' lastmodifier, '. TBL_AUTH_USER.' owner, '.TBL_AUTH_USER.' reporter, '. @@ -177,5 +178,5 @@ 'where v.project_id = %s and v.version_id = b.version_id(+) '. 'group by v.version_id, v.version_name, v.created_date, v.active', ); - + ?> Index: pgsql.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v retrieving revision 1.18 retrieving revision 1.19 diff -u -r1.18 -r1.19 --- pgsql.php 3 Sep 2002 19:45:01 -0000 1.18 +++ pgsql.php 13 Sep 2002 19:33:17 -0000 1.19 @@ -127,7 +127,8 @@ 'query-list-bugs-count' => 'select count(*) '. 'from '.TBL_BUG.' b '. 'left join '.TBL_AUTH_USER.' owner on b.assigned_to = owner.user_id '. - 'left join '.TBL_AUTH_USER.' reporter on b.created_by = reporter.user_id where ', + 'left join '.TBL_AUTH_USER.' reporter on b.created_by = reporter.user_id ', + 'query-list-bugs-count-join' => 'where ', 'query-list-bugs' => 'select %s '. 'from '.TBL_BUG.' b '. 'left join '.TBL_AUTH_USER.' owner on b.assigned_to = owner.user_id '. |