Changeset 27926 for trunk/ippTools/share/warptool_towarped.sql

Timestamp:

May 12, 2010, 10:23:55 AM (16 years ago)

Author:

bills

Message:

When updating an image use the original path base for consistency with the database

File:

• trunk/ippTools/share/warptool_towarped.sql (modified) (3 diffs)

trunk/ippTools/share/warptool_towarped.sql

@@ -11 +11 @@
     exp_tag,
     workdir,
-    magicked
+    magicked,
+    path_base
 FROM (
     SELECT DISTINCT
@@ -25 +26 @@
         rawExp.exp_tag,
         warpRun.workdir,
-        chipRun.magicked
+        chipRun.magicked,
+        CAST(NULL AS CHAR(255)) AS path_base
     FROM warpRun
     JOIN warpSkyCellMap
@@ -73 +75 @@
         rawExp.exp_tag,
         warpRun.workdir,
-        MIN(chipProcessedImfile.magicked) AS magicked
+        MIN(chipProcessedImfile.magicked) AS magicked,
+        warpSkyfile.path_base
     FROM warpRun
     JOIN warpImfile USING(warp_id)