Changeset 20954 for branches/bills_081204/ippTools/share/difftool_completed_runs.sql

Timestamp:

Dec 10, 2008, 6:11:39 PM (18 years ago)

Author:

bills

Message:

diff re-work nearly complete

File:

• branches/bills_081204/ippTools/share/difftool_completed_runs.sql (modified) (1 diff)

branches/bills_081204/ippTools/share/difftool_completed_runs.sql

@@ -3 +3 @@
 FROM (
     SELECT
+        COUNT(diffInputSkyfile.skycell_id), COUNT(diffSkyfile.skycell_id),
         diffSkyfile.*
     FROM diffRun
     JOIN diffInputSkyfile USING(diff_id)
-    LEFT JOIN diffSkyfile USING(diff_id)
+    LEFT JOIN diffSkyfile USING(diff_id, skycell_id)
     WHERE 
         diffRun.state = 'new'
     GROUP BY
-        diffSkyfile.diff_id
+        diffInputSkyfile.diff_id
     HAVING
-        COUNT(diffInputSkyfile.diff_id) = COUNT(diffSkyfile.diff_id)
+        COUNT(diffInputSkyfile.skycell_id) = COUNT(diffSkyfile.skycell_id)
         AND SUM(diffSkyfile.fault) = 0
     ) as Foo