Changeset 28364 for trunk/ippTools/share/diffphottool_advance.sql

Timestamp:

Jun 16, 2010, 2:41:22 PM (16 years ago)

Author:

Paul Price

Message:

Fixing advance mode: 'You can't specify target table 'diffPhotRun' for update in FROM clause' (error from MySQL)

File:

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

trunk/ippTools/share/diffphottool_advance.sql

@@ -1 @@
-UPDATE diffPhotRun
-SET state = 'full'
-WHERE diff_phot_id IN (
-    SELECT
-        diff_phot_id
-    FROM diffPhotRun
-    JOIN diffSkyfile USING(diff_id)
-    JOIN diffPhotSkyfile USING(diff_phot_id)
-    WHERE diffPhotRun.state = 'new'
-        AND diffPhotSkyfile.fault = 0
-        AND diffSkyfile.fault = 0
-        AND diffSkyfile.quality = 0
-        -- WHERE hook %s
-    HAVING COUNT(diffPhotSkyfile.skycell_id) = COUNT(diffSkyfile.skycell_id)
-) AS diffPhotRunsDone
+SELECT
+    diff_phot_id
+FROM diffPhotRun
+JOIN diffSkyfile USING(diff_id)
+JOIN diffPhotSkyfile USING(diff_phot_id)
+WHERE diffPhotRun.state = 'new'
+    AND diffPhotSkyfile.fault = 0
+    AND diffSkyfile.fault = 0
+    AND diffSkyfile.quality = 0
+-- WHERE hook %s
+HAVING COUNT(diffPhotSkyfile.skycell_id) = COUNT(diffSkyfile.skycell_id)