Changeset 27907 for trunk/ippTools/share/stacktool_tosum.sql

Timestamp:

May 10, 2010, 4:54:18 PM (16 years ago)

Author:

Paul Price

Message:

COUNT(expr) always returns the total number even if expr is false (because false is different from NULL). This means that the query would return stacks to do even if all the inputs aren't available. I've fixed this by recasting as SUM(IF(warpRun.state = 'full', 1, 0)).

File:

• trunk/ippTools/share/stacktool_tosum.sql (modified) (1 diff)

trunk/ippTools/share/stacktool_tosum.sql

@@ -16 +16 @@
     -- 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)