Author: fw
Date: 2005-09-14 21:26:09 +0000 (Wed, 14 Sep 2005)
New Revision: 1987
Modified:
lib/python/security_db.py
Log:
lib/python/security_db.py (DB.calculateVulnerabilities):
No version information means "unfixed", not "fixed".
Modified: lib/python/security_db.py
==================================================================---
lib/python/security_db.py 2005-09-14 21:19:35 UTC (rev 1986)
+++ lib/python/security_db.py 2005-09-14 21:26:09 UTC (rev 1987)
@@ -734,7 +734,7 @@
cursor.execute(
"""INSERT INTO source_package_status
SELECT n.id, p.rowid,
- p.version_id < n.fixed_version_id
+ n.fixed_version IS NULL OR p.version_id < n.fixed_version_id
FROM package_notes AS n, source_packages AS p
WHERE n.release = '''' AND p.name = n.package
AND NOT EXISTS (SELECT * FROM tmp_bug_releases AS t
@@ -745,7 +745,7 @@
cursor.execute(
"""INSERT INTO source_package_status
SELECT n.id, p.rowid,
- p.version_id < n.fixed_version_id
+ n.fixed_version IS NULL OR p.version_id < n.fixed_version_id
FROM package_notes AS n, source_packages AS p
WHERE p.name = n.package
AND (p.release = n.release
@@ -762,7 +762,7 @@
cursor.execute(
"""INSERT INTO binary_package_status
SELECT n.id, p.rowid,
- p.version_id < n.fixed_version_id
+ n.fixed_version IS NULL OR p.version_id < n.fixed_version_id
FROM package_notes AS n, binary_packages AS p
WHERE n.release = '''' AND p.name = n.package
AND (NOT EXISTS (SELECT * FROM tmp_bug_releases AS t
@@ -776,7 +776,7 @@
cursor.execute(
"""INSERT INTO binary_package_status
SELECT n.id, p.rowid,
- p.version_id < n.fixed_version_id
+ n.fixed_version IS NULL OR p.version_id < n.fixed_version_id
FROM package_notes AS n, binary_packages AS p
WHERE p.name = n.package
AND (p.release = n.release