Changeset 27838 for branches/tap_branches/ippTools/share/disttool_definebyquery_stack.sql

Timestamp:

May 3, 2010, 8:41:49 AM (16 years ago)

Author:

eugene

Message:

updates from trunk

Location:

branches/tap_branches

Files:

• . (modified) (1 prop)
• ippTools/share/disttool_definebyquery_stack.sql (modified) (2 diffs)

branches/tap_branches/ippTools/share/disttool_definebyquery_stack.sql

@@ -6 +6 @@
     CONCAT_WS('.', 'stack', stackRun.skycell_id, convert(stackRun.stack_id, CHAR)) as run_tag,
     stackRun.label,
+    stackRun.data_group,
     distTarget.dist_group,
     distTarget.target_id,
@@ -15 +16 @@
     AND stackRun.filter = distTarget.filter
 JOIN rcInterest USING(target_id)
-LEFT JOIN distRun ON distRun.stage = 'stack' AND (distRun.stage_id = stack_id)
-    AND distRun.clean = distTarget.clean
+LEFT JOIN distRun ON (distRun.stage_id = stack_id)
+    AND distRun.target_id = distTarget.target_id
     -- JOIN hook %s
 WHERE  distTarget.state = 'enabled'