Changeset 36963

Timestamp:

Jul 2, 2014, 3:23:17 PM (12 years ago)

Author:

watersc1

Message:

I need to change this because I have warp_ids that match chip_ids from a previous run. This seems to break that degeneracy, so if this moves on, I'll probably need to port this change to the other stage/defines.

The important thing is that for this label/stage combo, no run exists that also contains this label/stage/id combo.

File:

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

trunk/ippTools/share/remotetool_definebyquery_warp.sql

@@ -5 +5 @@
     LEFT JOIN remoteComponent ON (remoteComponent.stage_id = warpRun.warp_id)
     LEFT JOIN remoteRun ON (remoteComponent.remote_id = remoteRun.remote_id
-                        AND remoteRun.label = warpRun.label             )
+                        AND remoteRun.label = warpRun.label             
+                        AND (remoteRun.stage = 'warp' OR remoteRun.state IS NULL)
+                        )
 WHERE warpRun.state = 'new'
 AND (remoteRun.stage = 'warp' OR remoteRun.state IS NULL)
-AND remoteComponent.remote_id IS NULL
+-- AND remoteComponent.remote_id IS NULL
 -- where hook %s
 GROUP BY warp_id