Changeset 40535 for trunk/ippTools/share/dettool_tonormalizedstat.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_tonormalizedstat.sql (modified) (1 diff)

trunk/ippTools/share/dettool_tonormalizedstat.sql

@@ -10 +10 @@
   COUNT(detResidImfile.class_id)
 FROM detRun
+JOIN detInputExp
+    USING (det_id, iteration)
 JOIN detProcessedImfile
     ON  detProcessedImfile.det_id    = detRun.det_id
+    AND detProcessedImfile.exp_id    = detInputExp.exp_id
 LEFT JOIN detResidImfile
     ON  detResidImfile.det_id    = detProcessedImfile.det_id