Changeset 28768 for trunk/ippTools/share/magictool_toprocess_tree.sql

Timestamp:

Jul 29, 2010, 12:04:03 PM (16 years ago)

Author:

bills

Message:

order work to do by priority

File:

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

trunk/ippTools/share/magictool_toprocess_tree.sql

@@ -7 +7 @@
     -- note that the type stays a 64 bit int
     magicNodeResult.magic_id IS TRUE AS done,
-    magicNodeResult.fault IS TRUE AS bad
+    magicNodeResult.fault IS TRUE AS bad,
+    IFNULL(Label.priority, 10000) AS priority
 FROM magicTree
 JOIN magicRun USING(magic_id)
 JOIN rawExp USING(exp_id)
 LEFT JOIN magicNodeResult USING(magic_id, node)
+LEFT JOIN Label ON magicRun.label = Label.label
 WHERE
     magicRun.state = 'new'
 -- WHERE hook %s
 ORDER BY
-    magicRun.magic_id
+    priority, magicRun.magic_id