Changeset 32269 for trunk/ippTools/share/magictool_definebyquery_select.sql

Timestamp:

Aug 31, 2011, 6:07:03 PM (15 years ago)

Author:

watersc1

Message:

magictool definebyquery bugfix to exclude new runs based on exp_id/diff_id/label, not just on exp_id/label

File:

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

trunk/ippTools/share/magictool_definebyquery_select.sql

@@ -44 +44 @@
 JOIN rawExp USING(exp_id)
 LEFT JOIN
-    (SELECT magic_id, exp_id, label
+    (SELECT magic_id, exp_id, diff_id, label
         FROM magicRun
         -- rerun hook %s
     ) AS oldMagicRun
     ON oldMagicRun.exp_id = chipRun.exp_id
+    AND oldMagicRun.diff_id = diffWarps.diff_id
 -- WHERE hook %s
 GROUP BY chipRun.exp_id