Changeset 24106 for trunk/ippTools/share/receivetool_toadvance.sql

Timestamp:

May 7, 2009, 11:23:54 AM (17 years ago)

Author:

bills

Message:

Fix bugs in advance: use left join to receiveResult check for no faults

File:

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

trunk/ippTools/share/receivetool_toadvance.sql

@@ -9 +9 @@
     JOIN receiveSource USING(source_id)
     JOIN receiveFile USING(fileset_id)
-    JOIN receiveResult USING(file_id)
+    LEFT JOIN receiveResult USING(file_id)
 WHERE receiveFileset.state = 'new' 
     AND receiveFileset.fault = 0
 GROUP BY fileset_id 
 HAVING COUNT(receiveFile.file_id) = COUNT(receiveResult.file_id) 
+    AND SUM(receiveResult.fault) = 0