Changeset 23581 for branches/pap/ippTools/share/warptool_finished_run_select.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/warptool_finished_run_select.sql (modified) (1 diff)

branches/pap/ippTools/share/warptool_finished_run_select.sql

@@ -19 +19 @@
    HAVING
        COUNT(warpSkyCellMap.warp_id) = COUNT(warpSkyfile.warp_id)
-       AND SUM(warpSkyfile.fault) = 0
+       AND SUM(warpSkyfile.fault > 0) = 0
  ) as Foo