Changeset 36608 for tags/ipp-20140114

Timestamp:

Mar 20, 2014, 10:54:49 AM (12 years ago)

Author:

bills

Message:

don't try to advance fullForceRun's that already have a summary row

File:

• tags/ipp-20140114/ippTools/share/fftool_toadvance.sql (modified) (1 diff)

tags/ipp-20140114/ippTools/share/fftool_toadvance.sql

@@ -15 +15 @@
     JOIN rawExp USING(exp_id)
     LEFT JOIN fullForceResult USING(ff_id, warp_id)
-WHERE fullForceRun.state = 'new'
+    LEFT JOIN fullForceSummary USING(ff_id)
+WHERE fullForceRun.state = 'new' AND fullForceSummary.ff_id IS NULL
     -- WHERE hook %s
     GROUP BY ff_id