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

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

@@ -22 +22 @@
         detRun.mode,
         detRun.workdir,
-        detInputExp.exp_id,
-        rawExp.camera
+--      detInputExp.exp_id,
+--      this chooses a specific value
+--      for camera.  unclear if multiple
+--      camera were used
+        MIN(rawExp.camera) as camera
     FROM detRun
     JOIN detInputExp