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

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

@@ -14 +14 @@
 
 SELECT
-    detProcessedImfile.det_id,
+    -- why is this using detProcessedImfile.det_id and not detRun.det_id
+    -- MIN(detProcessedImfile.det_id) as det_id,
+    detRun.det_id,
     detRun.iteration,
     detRun.det_type,
     detRun.workdir,
     detRun.reduction,
-    detProcessedImfile.class_id,
-    rawExp.camera,
-    rawExp.exp_tag
+    -- detProcessedImfile.class_id could have NULLs given LEFT JOIN,
+    -- detProcessedImfile.class_id,
+    rawImfile.class_id,
+    MIN(rawExp.camera) AS camera
+    -- not needed in output?
+    -- rawExp.exp_tag
 FROM detRun
 JOIN detInputExp