Changeset 43014 for branches/eam_branches/ipp-pstamp-20260421/ippTools/share/warptool_towarped.sql

Timestamp:

May 11, 2026, 3:09:36 PM (2 months ago)

Author:

eugene

Message:

fix various SQL errors caught by more strict mysql versions, especially: force SQL to select a specific entry from non-aggregated fields when other fields are aggregated using e.g., GROUP BY

File:

• branches/eam_branches/ipp-pstamp-20260421/ippTools/share/warptool_towarped.sql (modified) (2 diffs)

branches/eam_branches/ipp-pstamp-20260421/ippTools/share/warptool_towarped.sql

@@ -74 +74 @@
         warpImfile.warp_skyfile_id,
         warpSkyCellMap.skycell_id,
-        warpSkyCellMap.tess_id,
+        MIN(warpSkyCellMap.tess_id) as tess_id,
         warpRun.fake_id,
         warpRun.state,
@@ -84 +84 @@
         warpRun.workdir,
         MIN(chipProcessedImfile.magicked) AS magicked,
-        warpSkyfile.path_base,
+        MIN(warpSkyfile.path_base) as past_base,
         IFNULL(Label.priority, 10000) AS priority
     FROM warpRun