Changeset 36853

Timestamp:

Jun 12, 2014, 5:24:29 PM (12 years ago)

Author:

watersc1

Message:

Corrections to sql to prevent double queuing

Location:

trunk/ippTools/share

Files:

• remotetool_definebyquery_cam.sql (modified) (1 diff)
• remotetool_definebyquery_stack.sql (modified) (1 diff)
• remotetool_definebyquery_warp.sql (modified) (1 diff)

trunk/ippTools/share/remotetool_definebyquery_cam.sql

@@ -9 +9 @@
 WHERE
 camRun.state = 'new' AND
-remoteRun.stage = 'camera' AND
-remote_id IS NULL
+(remoteRun.stage = 'camera' OR remoteRun.state IS NULL) AND
+remoteComponent.remote_id IS NULL

trunk/ippTools/share/remotetool_definebyquery_stack.sql

@@ -9 +9 @@
 WHERE
 stackRun.state = 'new' AND
-remoteRun.stage = 'stack' AND
-remote_id IS NULL
+(remoteRun.stage = 'stack' OR remoteRun.state IS NULL) AND
+remoteComponent.remote_id IS NULL

trunk/ippTools/share/remotetool_definebyquery_warp.sql

@@ -9 +9 @@
 WHERE
 warpRun.state = 'new' AND
-remoteRun.stage = 'warp' AND
-remote_id IS NULL
+(remoteRun.stage = 'warp' OR remoteRun.state IS NULL) AND
+remoteComponent.remote_id IS NULL