Changeset 36668 for trunk/ippTools/share/disttool_definebyquery_skycal.sql

Timestamp:

Apr 15, 2014, 3:49:31 PM (12 years ago)

Author:

bills

Message:

disttool -definebyquery -rerun didn't work

File:

• trunk/ippTools/share/disttool_definebyquery_skycal.sql (modified) (2 diffs)

trunk/ippTools/share/disttool_definebyquery_skycal.sql

@@ -1 @@
-SELECT
+SELECT DISTINCT
     'skycal' as stage,
     skycalRun.skycal_id AS stage_id,
@@ -21 +21 @@
 WHERE  distTarget.state = 'enabled'
     AND rcInterest.state = 'enabled'
-    AND distRun.dist_id IS NULL
     AND ((skycalRun.state = 'full') OR (distTarget.clean AND skycalRun.state = 'cleaned'))
     AND stackRun.filter = distTarget.filter