Changeset 28414 for trunk/ippTools/share/diffphottool_advance.sql

Timestamp:

Jun 18, 2010, 4:58:00 PM (16 years ago)

Author:

Paul Price

Message:

Fix advance mode to respect faults.

File:

• trunk/ippTools/share/diffphottool_advance.sql (modified) (2 diffs)

trunk/ippTools/share/diffphottool_advance.sql

@@ -3 +3 @@
 FROM diffPhotRun
 JOIN diffSkyfile USING(diff_id)
-JOIN diffPhotSkyfile USING(diff_phot_id)
+LEFT JOIN diffPhotSkyfile USING(diff_phot_id, skycell_id)
 WHERE diffPhotRun.state = 'new'
-    AND diffPhotSkyfile.fault = 0
     AND diffSkyfile.fault = 0
     AND diffSkyfile.quality = 0
@@ -11 +10 @@
 GROUP BY diff_phot_id
 HAVING COUNT(diffPhotSkyfile.skycell_id) = COUNT(diffSkyfile.skycell_id)
+    AND SUM(IF(diffPhotSkyfile.fault > 0, 1, 0)) = 0