Changeset 13997 for branches/backtrack/ippTools/share/chiptool_completely_processed_exp.sql

Timestamp:

Jul 2, 2007, 4:29:59 PM (19 years ago)

Author:

jhoblitt

Message:

rename chipPendingImfile table -> chipInputImfile

File:

• branches/backtrack/ippTools/share/chiptool_completely_processed_exp.sql (modified) (1 diff)

branches/backtrack/ippTools/share/chiptool_completely_processed_exp.sql

@@ -15 +15 @@
         chipProcessedImfile.class_id
     FROM chipRun
-    JOIN chipPendingImfile
+    JOIN chipInputImfile
         USING(chip_id)
     JOIN rawExp
-        ON chipPendingImfile.exp_tag = rawExp.exp_tag
+        ON chipInputImfile.exp_tag = rawExp.exp_tag
     JOIN chipProcessedImfile
-        ON chipPendingImfile.chip_id = chipProcessedImfile.chip_id
-        AND chipPendingImfile.exp_tag = chipProcessedImfile.exp_tag
-        AND chipPendingImfile.class_id = chipProcessedImfile.class_id
+        ON chipInputImfile.chip_id = chipProcessedImfile.chip_id
+        AND chipInputImfile.exp_tag = chipProcessedImfile.exp_tag
+        AND chipInputImfile.class_id = chipProcessedImfile.class_id
     WHERE
         chipRun.state = 'run'
         AND chipProcessedImfile.fault = 0
     GROUP BY
-        chipPendingImfile.chip_id,
-        chipPendingImfile.exp_tag
+        chipInputImfile.chip_id,
+        chipInputImfile.exp_tag
     HAVING rawExp.imfiles = COUNT(chipProcessedImfile.class_id)) as Foo