Changeset 43014 for branches/eam_branches/ipp-pstamp-20260421/ippTools/share/warptool_finished_run_select.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_finished_run_select.sql (modified) (1 diff)

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

@@ -6 +6 @@
        warpRun.warp_id,
        warpRun.label as label,
-       warpSkyCellMap.warp_id as foo,
-       warpSkyfile.warp_id as bar,
-       warpSkyfile.magicked as magicked
+--     these two fields are not used so we should not select for them
+--     warpSkyCellMap.warp_id as foo,
+--     warpSkyfile.warp_id as bar,
+--     this field is not guaranteed to be unique in the set for a single warp_id
+--     but the previous query version selected an arbitrary entry.  select
+--     the MIN to avoid trouble with the GROUP BY
+       MIN(warpSkyfile.magicked) as magicked
    FROM warpRun
    JOIN warpSkyCellMap