Changeset 28853

Timestamp:

Aug 5, 2010, 2:17:37 PM (16 years ago)

Author:

bills

Message:

magicdstool -torevert -stage chip was returning zillions of entries because
the join to chipProcessedImfile was incorrect

File:

• trunk/ippTools/share/magicdstool_torevert_chip.sql (modified) (2 diffs)

trunk/ippTools/share/magicdstool_torevert_chip.sql

@@ -2 +2 @@
     magic_ds_id,
     magicDSRun.state,
-    exp_id,
+    rawExp.exp_id,
     re_place,
     camera,
@@ -19 +19 @@
     JOIN camProcessedExp using(cam_id)
     JOIN chipRun ON (stage_id = chipRun.chip_id)
-    -- JOIN chipProcessedImfile ON (stage_id = chipProcessedImfile.chip_id AND component = class_id)
-    JOIN chipProcessedImfile USING(chip_id, exp_id)
-    JOIN rawExp using(exp_id)
+    JOIN chipProcessedImfile ON (stage_id = chipProcessedImfile.chip_id AND component = class_id)
+    JOIN rawExp ON chipRun.exp_id = rawExp.exp_id
 WHERE magicDSRun.stage = 'chip'
     AND ((magicDSRun.state = 'new' AND magicDSFile.fault > 0)