Changeset 28794 for branches/eam_branches/ipp-20100621/ippTools/share/magictool_totree.sql

Timestamp:

Jul 30, 2010, 9:31:50 AM (16 years ago)

Author:

eugene

Message:

updates from trunk

File:

• branches/eam_branches/ipp-20100621/ippTools/share/magictool_totree.sql (modified) (2 diffs)

branches/eam_branches/ipp-20100621/ippTools/share/magictool_totree.sql

@@ -6 +6 @@
     ra,
     decl,
-    diffRun.tess_id
+    diffRun.tess_id,
+    IFNULL(priority, 10000) AS priority
 FROM magicRun
 JOIN diffRun USING(diff_id)
@@ -12 +13 @@
 LEFT JOIN magicTree
     USING(magic_id)
+LEFT JOIN Label ON magicRun.label = Label.label
 WHERE
     magicRun.state = 'new'