Revision: 987 http://trac.macosforge.org/projects/darwinbuild/changeset/987 Author: wsiegrist@apple.com Date: 2011-11-17 16:42:32 -0800 (Thu, 17 Nov 2011) Log Message: ----------- Fix SQL to correctly return new projects that were not in the old build Modified Paths: -------------- trunk/darwinxref/DBDataStore.c Modified: trunk/darwinxref/DBDataStore.c =================================================================== --- trunk/darwinxref/DBDataStore.c 2011-11-17 21:45:57 UTC (rev 986) +++ trunk/darwinxref/DBDataStore.c 2011-11-18 00:42:32 UTC (rev 987) @@ -326,7 +326,7 @@ "UNION " "SELECT DISTINCT project FROM properties " "WHERE build=%Q " - "AND project NOT IN (SELECT project FROM properties WHERE build=%Q) " + "AND project NOT IN (SELECT project FROM properties WHERE build=%Q and project != '') " "ORDER BY project", cnewbuild, coldbuild, cnewbuild, coldbuild); free(coldbuild); free(cnewbuild);