Changeset 24788 for trunk/ippTools/share/receivetool_pendingfileset.sql

Timestamp:

Jul 14, 2009, 1:56:39 PM (17 years ago)

Author:

bills

Message:

Fix a couple of race conditions with regard to fileset state changes

File:

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

trunk/ippTools/share/receivetool_pendingfileset.sql

@@ -1 +1 @@
 SELECT *
 FROM receiveFileset
-WHERE state = 'reg'
-    AND fault = 0
+JOIN receiveSource USING(source_id)
+LEFT JOIN receiveFile USING(fileset_id)
+WHERE receiveFileset.state = 'reg'
+    AND receiveFileset.fault = 0
+    AND receiveFile.fileset_id IS NULL