Changeset 36964

Timestamp:

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

Author:

watersc1

Message:

sql bug fix.

File:

• tags/ipp-pv3-20140616/ippTools/share/remotetool_definebyquery_warp.sql (modified) (1 diff)

tags/ipp-pv3-20140616/ippTools/share/remotetool_definebyquery_warp.sql

@@ -1 @@
-SELECT 
-       warp_id AS stage_id
-FROM warpRun 
-       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
-            )
-WHERE
-warpRun.state = 'new' AND
-(remoteRun.stage = 'warp' OR remoteRun.state IS NULL) AND
-remoteComponent.remote_id IS NULL
+SELECT warp_id AS stage_id FROM (
+SELECT warp_id, count(warpSkyCellMap.skycell_id) AS N
+    FROM warpRun
+    LEFT JOIN warpSkyCellMap USING(warp_id)
+    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.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
+-- where hook %s
+GROUP BY warp_id
+) AS warpTry
+WHERE N != 0
+