Changeset 26927 for trunk/ippTools/share/difftool_pendingcleanuprun.sql

Timestamp:

Feb 12, 2010, 12:21:48 PM (16 years ago)

Author:

watersc1

Message:

Implement stackstack diff mode, based on already existing warpstack code.

Rework cleanup sql a bit to be lighter on the database server.

File:

• trunk/ippTools/share/difftool_pendingcleanuprun.sql (modified) (6 diffs)

trunk/ippTools/share/difftool_pendingcleanuprun.sql

@@ -25 +25 @@
             USING(exp_id)
         WHERE
+        @INNERCONSTRAINT@
             (diffRun.state = 'goto_cleaned' OR 
              diffRun.state = 'goto_scrubbed' OR 
@@ -52 +53 @@
             USING(exp_id)
         WHERE
+        @INNERCONSTRAINT@
             (diffRun.state = 'goto_cleaned' OR 
              diffRun.state = 'goto_scrubbed' OR 
@@ -64 +66 @@
         JOIN diffInputSkyfile
             USING(diff_id)
-        JOIN stackSumSkyfile
-            ON  diffInputSkyfile.stack1 = stackSumSkyfile.stack_id
+--      JOIN stackSumSkyfile
+--          ON  diffInputSkyfile.stack1 = stackSumSkyfile.stack_id
         JOIN stackInputSkyfile
             ON diffInputSkyfile.stack1 = stackInputSkyfile.stack_id
@@ -79 +81 @@
             USING(exp_id)
         WHERE
+        @INNERCONSTRAINT@
             (diffRun.state = 'goto_cleaned' OR 
              diffRun.state = 'goto_scrubbed' OR 
@@ -91 +94 @@
         JOIN diffInputSkyfile
             USING(diff_id)
-        JOIN stackSumSkyfile
-            ON  diffInputSkyfile.stack2 = stackSumSkyfile.stack_id
+--      JOIN stackSumSkyfile
+--          ON  diffInputSkyfile.stack2 = stackSumSkyfile.stack_id
         JOIN stackInputSkyfile
             ON diffInputSkyfile.stack2 = stackInputSkyfile.stack_id
@@ -106 +109 @@
             USING(exp_id)
         WHERE
+        @INNERCONSTRAINT@
             (diffRun.state = 'goto_cleaned' OR 
              diffRun.state = 'goto_scrubbed' OR