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

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

@@ -33 +33 @@
          JOIN 
          (
-          select DISTINCT newExp.exp_id,
-          rawImfile.camera,
-          rawImfile.filter,
-          rawImfile.dateobs,
-          rawImfile.obs_mode,
-          rawImfile.obs_group,
+          select DISTINCT
+          MIN(newExp.exp_id) as exp_id,
+          MIN(rawImfile.camera) as camera,
+          MIN(rawImfile.filter) as filter,
+          MIN(rawImfile.dateobs) as dateobs,
+          MIN(rawImfile.obs_mode) as obs_mode,
+          MIN(rawImfile.obs_group) as obs_group,
           count(rawImfile.tmp_class_id) AS raw_count
           from newExp