Changeset 18950 for trunk/ippTools/share/warptool_warped.sql

Timestamp:

Aug 7, 2008, 5:40:54 PM (18 years ago)

Author:

bills

Message:

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

File:

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

trunk/ippTools/share/warptool_warped.sql

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