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

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

@@ -4 +4 @@
     skycell_id,
     rawExp.exp_tag,
-    rawExp.camera
+    rawExp.camera,
+    -- EAM: this was missing, I think this was a legitimate error
+    priority
 FROM warpBackgroundRun
 JOIN warpRun USING(warp_id)