Changeset 24789

Timestamp:

Jul 14, 2009, 3:23:34 PM (17 years ago)

Author:

bills

Message:

Add DISTINCT to prevent queuing multiple distRuns for runs that have multiple interests

Location:

trunk/ippTools/share

Files:

• disttool_definebyquery_camera.sql (modified) (1 diff)
• disttool_definebyquery_chip.sql (modified) (1 diff)
• disttool_definebyquery_fake.sql (modified) (1 diff)
• disttool_definebyquery_warp.sql (modified) (1 diff)

trunk/ippTools/share/disttool_definebyquery_camera.sql

@@ -1 @@
-SELECT
+SELECT DISTINCT
     'camera' as stage,
     camRun.cam_id as stage_id,

trunk/ippTools/share/disttool_definebyquery_chip.sql

@@ -1 @@
-SELECT
+SELECT DISTINCT
     'chip' as stage,
     chipRun.chip_id as stage_id,

trunk/ippTools/share/disttool_definebyquery_fake.sql

@@ -1 @@
-SELECT
+SELECT DISTINCT
     'fake' as stage,
     fakeRun.fake_id AS stage_id,

trunk/ippTools/share/disttool_definebyquery_warp.sql

@@ -1 @@
-SELECT
+SELECT DISTINCT
     'warp' as stage,
     warpRun.warp_id AS stage_id,