Changeset 9407

Timestamp:

Oct 8, 2006, 12:58:06 PM (20 years ago)

Author:

eugene

Message:

added AND clause to restrict -updatedetrun to specified det_id (was causing havoc otherwise)

File:

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

trunk/ippTools/src/dettool.c

@@ -4069 +4069 @@
         "   AND detInputExp.exp_tag = detResidExp.exp_tag"
         " WHERE"
-        "   detRun.state = 'run'"
-        " GROUP BY"
+        "   detRun.state = 'run'");
+    
+    // XXX this query was not restricted by det_id, resulting 
+    // in an inconsistent UPDATE below.  I added this AND clause
+    // though there may be a cleaner method (EAM 2006.10.08)
+    psStringAppend (
+        &query,
+        "  AND detRun.position = '%s'", det_id);
+
+    psStringAppend (
+        &query, 
+        " GROUP BY"
         "   detRun.position,"
         "   detRun.iteration,"
@@ -4096 +4106 @@
         return true;
     }
-
+    
     // start a transaction so we don't end up with an incremented iteration
     // count but no detInputExps