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

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

@@ -8 +8 @@
 FROM (
     SELECT
-        pzDownloadImfile.*,
+        pzDownloadImfile.summit_id as summit_id,
+        MIN(pzDownloadImfile.exp_name) as exp_name,
+        MIN(pzDownloadImfile.camera) as camera,
+        MIN(pzDownloadImfile.telescope) as telescope,
         pzDownloadExp.state,
         summitExp.imfiles,