Changeset 13969 for branches/backtrack/ippTools/share/regtool_pendingexp.sql

Timestamp:

Jun 25, 2007, 10:47:22 AM (19 years ago)

Author:

jhoblitt

Message:

overhaul new* -> raw* table transistions to keep the complete history

File:

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

branches/backtrack/ippTools/share/regtool_pendingexp.sql

@@ -2 +2 @@
     newExp.*
 FROM newExp
-LEFT JOIN newImfile
+JOIN newImfile
     USING(exp_tag)
 LEFT JOIN rawExp
     USING(exp_tag)
 WHERE
-    newImfile.exp_tag IS NULL
+    newExp.state = 'run'
     AND rawExp.exp_tag IS NULL
     AND newExp.imfiles =