Changeset 9330

Timestamp:

Oct 5, 2006, 4:12:32 PM (20 years ago)

Author:

jhoblitt

Message:

make sure det_id & iteration (where relevant) is in all SQL stmts

File:

• trunk/ippTools/src/dettool.c (modified) (4 diffs)

trunk/ippTools/src/dettool.c

@@ -1332 +1332 @@
         "    detProcessedImfile.class_id,"
         "    rawImfile.class_id"
+        "    detRun.position"
         " HAVING"
         "    COUNT(detProcessedImfile.class_id) = COUNT(rawImfile.class_id)"
@@ -1480 +1481 @@
         "   AND detInputExp.include = 1"
         " GROUP BY"
-        "    rawImfile.class_id"
+        "    rawImfile.class_id,"
+        "    detRun.position"
         " HAVING"
         "    COUNT(detProcessedImfile.class_id) = COUNT(rawImfile.class_id)"
@@ -3668 +3670 @@
         "   GROUP BY"
         "       detInputExp.exp_tag,"
-        "       detInputExp.iteration,"
-        "       detInputExp.det_id"
+        "       detRun.iteration,"
+        "       detRun.position"
         "   HAVING"
         "       rawDetrendExp.imfiles = COUNT(detResidImfile.class_id)"
@@ -3784 +3786 @@
         "   GROUP BY"
         "       detInputExp.exp_tag,"
-        "       detInputExp.iteration,"
-        "       detInputExp.det_id"
+        "       detRun.iteration,"
+        "       detRun.position"
         "   HAVING"
         "       rawDetrendExp.imfiles = COUNT(detResidImfile.class_id)"