Changeset 26857 for branches/eam_branches/20091201/ippTools/share/chiptool_completely_processed_exp.sql

Timestamp:

Feb 10, 2010, 3:52:15 PM (16 years ago)

Author:

eugene

Message:

various updates from trunk (mostly magic state handling, dqstats)

File:

• branches/eam_branches/20091201/ippTools/share/chiptool_completely_processed_exp.sql (modified) (2 diffs)

branches/eam_branches/20091201/ippTools/share/chiptool_completely_processed_exp.sql

@@ -14 +14 @@
     tess_id,
     end_stage,
-    all_files_magicked as magicked,
+    imfile_magicked as magicked,
     note
 FROM
@@ -21 +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