Changeset 18793

Timestamp:

Jul 30, 2008, 2:32:56 PM (18 years ago)

Author:

Paul Price

Message:

Missing constraint on LEFT JOIN with fakeProcessedImfile was leaving out lots of GPC chips.

File:

• trunk/ippTools/share/faketool_pendingimfile.sql (modified) (3 diffs)

trunk/ippTools/share/faketool_pendingimfile.sql

@@ -1 @@
-SELECT DISTINCT * FROM 
-     -- the subselect is so where criteria can be specified without knowing
-     -- which table the field came from
-    (SELECT
+SELECT DISTINCT * FROM (
+    -- the subselect is so where criteria can be specified without knowing
+    -- which table the field came from
+    SELECT
         fakeRun.*,
         chipProcessedImfile.exp_id,
@@ -29 +29 @@
         rawExp.filelevel
     FROM fakeRun
-    JOIN camRun
-        USING(cam_id)
-    JOIN camProcessedExp
-        USING(cam_id)
-    JOIN chipRun
-        USING(chip_id)
-    JOIN chipProcessedImfile
-        USING(chip_id)
+    JOIN camRun USING(cam_id)
+    JOIN camProcessedExp USING(cam_id)
+    JOIN chipRun USING(chip_id)
+    JOIN chipProcessedImfile USING(chip_id)
     JOIN rawExp
         ON chipProcessedImfile.exp_id = rawExp.exp_id
     LEFT JOIN fakeProcessedImfile
         ON fakeRun.fake_id = fakeProcessedImfile.fake_id
+        AND chipProcessedImfile.class_id = fakeProcessedImfile.class_id
     LEFT JOIN fakeMask
         ON fakeRun.label = fakeMask.label
@@ -47 +44 @@
         AND fakeProcessedImfile.class_id IS NULL
         AND fakeMask.label IS NULL
-    ) as foo
+    ) as fakePendingImfile