Changeset 25493 for trunk/ippTools/share/disttool_queuercrun.sql

Timestamp:

Sep 23, 2009, 10:22:33 AM (17 years ago)

Author:

bills

Message:

In distribution server merge rcDSProduct into rcDestination. It was illogical for
a product to be shared by multiple destinations.
In defineinterest define by query to allow destination names and target parameters
to be used. Much more administrator friendly.
Add a label to pstampRequest. Not used yet.
Split reverting of faults in distRuns from faults building components.

File:

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

trunk/ippTools/share/disttool_queuercrun.sql

@@ -13 +13 @@
 JOIN rcInterest USING(dest_id) 
 JOIN distTarget USING(target_id) 
-JOIN rcDSProduct USING(prod_id)
 JOIN distRun USING(target_id, stage) 
-JOIN rcDSFileset USING(prod_id, dist_id)
+JOIN rcDSFileset USING(dest_id, dist_id)
 LEFT JOIN rcRun using(fs_id, dest_id)
 WHERE rcRun.rc_id IS NULL