Changeset 27840 for branches/simtest_nebulous_branches/ippTools/share/stacktool_tosum.sql

Timestamp:

May 3, 2010, 8:50:52 AM (16 years ago)

Author:

eugene

Message:

updates from trunk

Location:

branches/simtest_nebulous_branches

Files:

• . (modified) (1 prop)
• ippTools/share/stacktool_tosum.sql (modified) (2 diffs)

branches/simtest_nebulous_branches/ippTools/share/stacktool_tosum.sql

@@ -1 @@
-SELECT DISTINCT
+SELECT
     stackRun.stack_id,
     stackRun.tess_id,
@@ -8 +8 @@
     stackRun.state
 FROM stackRun
-JOIN stackInputSkyfile
-    USING(stack_id)
-LEFT JOIN stackSumSkyfile
-    USING(stack_id)
+JOIN stackInputSkyfile USING(stack_id)
+JOIN warpRun USING(warp_id)
+LEFT JOIN stackSumSkyfile USING(stack_id)
 WHERE
     ((stackRun.state = 'new' AND stackSumSkyfile.stack_id IS NULL)
     OR (stackRun.state = 'update' AND stackSumSkyfile.fault = 0 AND stackSumSkyfile.quality = 0))
+    -- WHERE hook %s
+GROUP BY stack_id
+HAVING COUNT(warpRun.state = 'full') = COUNT(stackInputSkyfile.warp_id)