Changeset 15271

Timestamp:

Oct 9, 2007, 3:29:31 PM (19 years ago)

Author:

jhoblitt

Message:

update

File:

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

trunk/ippTools/share/magictool_toprocess.sql

@@ -1 +1 @@
 SELECT
-    magicTree.*
+    magicTree.*,
+    -- convert magic_id into a boolean value (1 or 0)
+    -- note that the type stays a 64 bit int
+    magicNodeResult.magic_id IS TRUE as done
 FROM magicTree
+JOIN magicRun
+    USING(magic_id)
 LEFT JOIN magicNodeResult
     ON magicTree.magic_id = magicNodeResult.magic_id
-    AND magicTree.dep = magicNodeResult.node
+    AND magicTree.node = magicNodeResult.node
 WHERE
-    magicNodeResult.node IS NULL
+    magicRun.state = 'run'