Changeset 40535 for trunk/ippTools/share/dettool_toresidimfile.sql

Timestamp:

Sep 26, 2018, 12:20:28 PM (8 years ago)

Author:

eugene

Message:

fix processing if number of inputs is not the same as number of stacks

File:

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

trunk/ippTools/share/dettool_toresidimfile.sql

@@ -21 +21 @@
 FROM detRun
 JOIN detInputExp
-    USING(det_id, iteration)
+--  USING(det_id, iteration)
+    ON detInputExp.det_id = detRun.det_id
+    AND detInputExp.iteration = detRun.iteration
+--  AND detInputExp.iteration = 0
 JOIN rawExp
     ON detInputExp.exp_id = rawExp.exp_id
@@ -77 +80 @@
   ON detInputExp.det_id    = detRun.det_id
  AND detInputExp.iteration = detRun.iteration
+-- AND detInputExp.iteration = 0
 JOIN rawExp
   ON rawExp.exp_id = detInputExp.exp_id
@@ -123 +127 @@
   ON detInputExp.det_id    = detRun.det_id
  AND detInputExp.iteration = detRun.iteration
+-- AND detInputExp.iteration = 0
 JOIN rawExp
   ON rawExp.exp_id = detInputExp.exp_id