Changeset 27840 for branches/simtest_nebulous_branches/ippTools/share/chiptool_completely_processed_exp.sql

Timestamp:

May 3, 2010, 8:50:52 AM (16 years ago)

Author:

eugene

Message:

updates from trunk

Location:

branches/simtest_nebulous_branches

Files:

• . (modified) (1 prop)
• ippTools/share/chiptool_completely_processed_exp.sql (modified) (3 diffs)

branches/simtest_nebulous_branches/ippTools/share/chiptool_completely_processed_exp.sql

@@ -7 +7 @@
     workdir_state,
     label,
+    data_group,
+    dist_group,
     reduction,
     expgroup,
@@ -12 +14 @@
     tess_id,
     end_stage,
-    all_files_magicked as magicked
+    imfile_magicked as magicked,
+    note
 FROM
     (SELECT
@@ -18 +21 @@
         rawImfile.class_id as rawimfile_class_id,
         chipProcessedImfile.class_id,
-        SUM(!chipProcessedImfile.magicked) = 0 as all_files_magicked
+        -- XXX using chipProcessedImfile assumes that all imfile's have
+        -- the same magicked value if that isn't right then more than one 
+        -- row will be returned. In practice this is the case but bugs could
+        -- cause it to not be true.
+        -- We could use rawExp.magicked but that would make it possible for
+        -- the chipRun to have a different magicked value than the imfiles
+        chipProcessedImfile.magicked AS imfile_magicked
     FROM chipRun
     JOIN rawImfile