Menu
▾
▴
[phpBT-dev] CVS: phpbt/inc/db mysql.php,1.16,1.17 oci8.php,1.14,1.15 pgsql.php,1.23,1.24
|
From: Benjamin C. <bc...@us...> - 2003-06-21 13:36:34
|
Update of /cvsroot/phpbt/phpbt/inc/db In directory sc8-pr-cvs1:/tmp/cvs-serv8926/inc/db Modified Files: mysql.php oci8.php pgsql.php Log Message: Fixes bug #701852 - Prev/Next bug queries failing on the recently-added bug fields Index: mysql.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v retrieving revision 1.16 retrieving revision 1.17 diff -u -r1.16 -r1.17 --- mysql.php 19 Apr 2003 18:12:40 -0000 1.16 +++ mysql.php 21 Jun 2003 13:36:30 -0000 1.17 @@ -75,7 +75,10 @@ '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 '. 'left join '.TBL_AUTH_USER.' lastmodifier on b.last_modified_by = lastmodifier.user_id '. - 'left join '.TBL_RESOLUTION.' resolution on b.resolution_id = resolution.resolution_id, '. + 'left join '.TBL_RESOLUTION.' resolution on b.resolution_id = resolution.resolution_id '. + 'left join '.TBL_DATABASE.' on b.database_id = '.TBL_DATABASE.'.database_id '. + 'left join '.TBL_VERSION.' version2 on b.to_be_closed_in_version_id = version2.version_id '. + 'left join '.TBL_VERSION.' version3 on b.closed_in_version_id = version3.version_id, '. TBL_SEVERITY.' severity, '.TBL_STATUS.' status, '.TBL_OS.' os, '. TBL_VERSION.' version, '.TBL_COMPONENT.' component, '. TBL_PROJECT.' project, '.TBL_SITE.' site '. Index: oci8.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v retrieving revision 1.14 retrieving revision 1.15 diff -u -r1.14 -r1.15 --- oci8.php 19 Apr 2003 18:12:41 -0000 1.14 +++ oci8.php 21 Jun 2003 13:36:30 -0000 1.15 @@ -77,13 +77,18 @@ 'owner.login as owner '. 'from '.TBL_BUG.' b, '.TBL_AUTH_USER.' owner, '.TBL_AUTH_USER.' reporter, '. TBL_AUTH_USER.' lastmodifier, ' . TBL_RESOLUTION.' resolution, '. - TBL_SEVERITY.' severity, ' . TBL_STATUS.' status, '.TBL_OS.' os, '. + TBL_DATABASE.' database, '.TBL_VERSION.' version2, '. + TBL_VERSION.' version3, '.TBL_SEVERITY.' severity, '. + TBL_STATUS.' status, '.TBL_OS.' os, '. TBL_VERSION.' version, '.TBL_COMPONENT.' component, '. TBL_PROJECT.' project, '.TBL_SITE.' site '. 'where b.assigned_to = owner.user_id(+) '. 'and b.created_by = reporter.user_id(+) '. 'and b.last_modified_by = lastmodifier.user_id(+) '. 'and b.resolution_id = resolution.resolution_id(+) '. + 'and b.database_id = database.database_id(+) '. + 'and b.to_be_closed_in_version_id = version2.version_id(+) '. + 'and b.closed_in_version_id = version3.version_id(+) '. 'and b.severity_id = severity.severity_id '. 'and b.status_id = status.status_id and b.os_id = os.os_id '. 'and b.version_id = version.version_id '. Index: pgsql.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v retrieving revision 1.23 retrieving revision 1.24 diff -u -r1.23 -r1.24 --- pgsql.php 19 Apr 2003 18:12:41 -0000 1.23 +++ pgsql.php 21 Jun 2003 13:36:30 -0000 1.24 @@ -76,7 +76,10 @@ '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 '. 'left join '.TBL_AUTH_USER.' lastmodifier on b.last_modified_by = lastmodifier.user_id '. - 'left join '.TBL_RESOLUTION.' resolution on b.resolution_id = resolution.resolution_id, '. + 'left join '.TBL_RESOLUTION.' resolution on b.resolution_id = resolution.resolution_id '. + 'left join '.TBL_DATABASE.' on b.database_id = '.TBL_DATABASE.'.database_id '. + 'left join '.TBL_VERSION.' version2 on b.to_be_closed_in_version_id = version2.version_id '. + 'left join '.TBL_VERSION.' version3 on b.closed_in_version_id = version3.version_id, '. TBL_SEVERITY.' severity, '.TBL_STATUS.' status, '.TBL_OS.' os, '. TBL_VERSION.' version, '.TBL_COMPONENT.' component, '. TBL_PROJECT.' project, '.TBL_SITE.' site '. |
