Changeset 14023 for trunk/ippTools/share/regtool_find_unprocessed_exp.sql

Timestamp:

Jul 5, 2007, 3:16:08 PM (19 years ago)

Author:

jhoblitt

Message:

rename exp_id -> exp_name
rename exp_tag -> exp_id
add add rawExp.exp_tag for use as an external name only

File:

• trunk/ippTools/share/regtool_find_unprocessed_exp.sql (modified) (1 diff)

trunk/ippTools/share/regtool_find_unprocessed_exp.sql

@@ -4 +4 @@
     FROM newExp
     JOIN newImfile
-       USING(exp_tag)
+       USING(exp_id)
     LEFT JOIN rawExp
-       USING(exp_tag)
+       USING(exp_id)
     WHERE
         newExp.state = 'run'
-        AND rawExp.exp_tag IS NULL
+        AND rawExp.exp_id IS NULL
         AND newExp.imfiles =
-        (SELECT COUNT(exp_tag) FROM rawImfile
-            WHERE rawImfile.exp_tag = newExp.exp_tag)) as Foo
+        (SELECT COUNT(exp_id) FROM rawImfile
+            WHERE rawImfile.exp_id = newExp.exp_id)) as Foo
 WHERE
-    exp_tag = '%s'
+    exp_id = '%s'