Changeset 19526 for trunk/ippTools/share/stacktool_pendingcleanuprun.sql

Timestamp:

Sep 11, 2008, 3:31:21 PM (18 years ago)

Author:

bills

Message:

use DISTINCT to get the right set of runs

File:

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

trunk/ippTools/share/stacktool_pendingcleanuprun.sql

@@ -1 @@
--- results in too many output files
--- is the camera needed for this?
--- is the camera unique for this?
-SELECT
+-- results in too many runs                 adding DISTINCT fixes this
+-- is the camera needed for this?           YES I think so that update can define the camera
+-- is the camera unique for this?           YES. Well, sort of.
+--                                          stack_skycell.pl insures that the files
+--                                          we're here to clean come from the same camera so
+--                                          if the camera is not unique we have nothing to do
+SELECT DISTINCT
     stackRun.stack_id,
     rawExp.camera,