Changeset 23581 for branches/pap/ippTools/share/difftool_definebyquery_part1.sql

Timestamp:

Mar 27, 2009, 5:12:32 PM (17 years ago)

Author:

Paul Price

Message:

Set some bounds on data-quality for various operations. QUALITY isn't a boolean value, but integer.

File:

• branches/pap/ippTools/share/difftool_definebyquery_part1.sql (modified) (1 diff)

branches/pap/ippTools/share/difftool_definebyquery_part1.sql

@@ -8 +8 @@
     FROM warpRun
     JOIN warpSkyfile USING(warp_id)
-    JOIN fakeRun USING(fake_id) 
-    JOIN camRun USING(cam_id) 
-    JOIN chipRun USING (chip_id) 
+    JOIN fakeRun USING(fake_id)
+    JOIN camRun USING(cam_id)
+    JOIN chipRun USING (chip_id)
     JOIN rawExp USING(exp_id)
     LEFT JOIN diffRun USING(exp_id)
 
     WHERE
+        warpSkyfile.fault = 0
         warpSkyfile.ignored = 0
+        AND warpSkyfile.quality = 0
         -- warp where hook %s
         -- exp where hook %s