Changeset 14023 for trunk/ippTools/share/regtool_pendingexp.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_pendingexp.sql (modified) (1 diff)

trunk/ippTools/share/regtool_pendingexp.sql

@@ -3 +3 @@
 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
+    (SELECT COUNT(exp_id) FROM rawImfile
         WHERE
-            rawImfile.exp_tag = newExp.exp_tag
+            rawImfile.exp_id = newExp.exp_id
             AND rawImfile.fault = 0)