Changeset 26567 for trunk/ippTools/share/warptool_finished_run_select.sql

Timestamp:

Jan 12, 2010, 2:07:51 PM (16 years ago)

Author:

bills

Message:

Make update processing compatible with magic. Fix some bugs in update for the warp stage
Make script changes to implement update for diff stage.
Change value of 'magicked' in the various runs and files to contain the value
the magic_id of the magicRun that corresponds to the streaks file used for desreaking.

File:

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

trunk/ippTools/share/warptool_finished_run_select.sql

@@ -8 +8 @@
        warpSkyCellMap.warp_id as foo,
        warpSkyfile.warp_id as bar,
-       SUM(!warpSkyfile.magicked) = 0 as magicked
+       warpSkyfile.magicked as magicked
    FROM warpRun
    JOIN warpSkyCellMap