Changeset 24788 for trunk/ippTools/share/receivetool_pendingfile.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_pendingfile.sql (modified) (1 diff)

trunk/ippTools/share/receivetool_pendingfile.sql

@@ -18 +18 @@
     ON receiveResult.file_id = receiveFile.file_id
 WHERE
-    ((receiveFileset.state = 'new') OR (receiveFileset.state = 'listed' AND receiveFile.component = 'dirinfo'))
+    ((receiveFileset.state = 'new')
+    OR (receiveFileset.state = 'listed' AND receiveFile.component = 'dirinfo' AND receiveFileset.dirinfo IS NULL))
     AND receiveFileset.fault = 0
     AND receiveResult.file_id IS NULL