Changeset 18951 for trunk/ippTools/share/stacktool_sumskyfile.sql

Timestamp:

Aug 7, 2008, 5:41:36 PM (18 years ago)

Author:

bills

Message:

in mode -sumskyfile don't require state to be run and output the state

File:

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

trunk/ippTools/share/stacktool_sumskyfile.sql

@@ -1 +1 @@
 SELECT
-    stackSumSkyfile.*
+    stackSumSkyfile.*,
+    stackRun.state
 FROM stackRun
 JOIN stackSumSkyfile
     USING(stack_id)
 WHERE
-    stackRun.state = 'run'
+-- bogus test; just here so there there is a 'WHERE' stmt to append conditionals too
+    stackRun.stack_id is NOT NULL