Changeset 27199 for trunk

Timestamp:

Mar 4, 2010, 5:14:49 PM (16 years ago)

Author:

watersc1

Message:

This was marking exposures as fully done, even when they weren't. New revision corrects this (and is more fully tested than before).

File:

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

trunk/ippTools/share/regtool_finishcompressexp.sql

@@ -67 +67 @@
     magicked
 FROM
-    (SELECT
-        rawExp.*,
-        count(rawImfile.class_id) AS complete,
-        count(newImfile.tmp_class_id) AS total
-        FROM rawExp
-        JOIN newImfile
-             ON rawExp.exp_id = newImfile.exp_id
-        LEFT JOIN rawImfile
-             ON rawExp.exp_id = rawImfile.exp_id
-             AND rawImfile.tmp_class_id = newImfile.tmp_class_id
-        WHERE
-             ((rawExp.state = 'goto_compressed' 
-               AND rawImfile.data_state = 'compressed')OR
-              (rawExp.state = 'goto_lossy'
-               AND rawImfile.data_state = 'lossy'))
-        GROUP BY
-              rawExp.exp_id
-      ) as foo
-      WHERE (foo.complete = foo.total)
+    (SELECT V.*,
+     count(class_id) AS complete
+     FROM 
+          (SELECT rawExp.*,count(newImfile.tmp_class_id) AS total
+           FROM rawExp
+           LEFT JOIN newImfile ON rawExp.exp_id = newImfile.exp_id
+           WHERE (rawExp.state = 'goto_compressed' OR rawExp.state = 'goto_lossy') 
+           GROUP BY rawExp.exp_id) AS V
+     JOIN rawImfile ON V.exp_id = rawImfile.exp_id
+     WHERE ((V.state = 'goto_compressed' AND rawImfile.data_state = 'compressed') OR
+            (V.state = 'goto_lossy' AND rawImfile.data_state = 'lossy'))
+     GROUP BY V.exp_id) as foo
+WHERE (foo.complete = foo.total)
         
-