Changeset 28003 for branches/pap/ippTools/share/stacktool_tosum.sql

Timestamp:

May 18, 2010, 12:49:05 PM (16 years ago)

Author:

eugene

Message:

merging changes from trunk into branches/pap

Location:

branches/pap

Files:

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

branches/pap/ippTools/share/stacktool_tosum.sql

@@ -6 +6 @@
     stackRun.reduction,
     stackRun.label,
-    stackRun.state
+    stackRun.state,
+    stackSumSkyfile.path_base
 FROM stackRun
 JOIN stackInputSkyfile USING(stack_id)
@@ -16 +17 @@
     -- WHERE hook %s
 GROUP BY stack_id
-HAVING COUNT(warpRun.state = 'full') = COUNT(stackInputSkyfile.warp_id)
+HAVING SUM(IF(warpRun.state = 'full', 1, 0)) = COUNT(stackInputSkyfile.warp_id)