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

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

@@ -1 +1 @@
 -- this is used by both 'tonormalizedexp' and 'addnormalizedexp'
+
+-- EAM : I believe the outer SELECT * FROM () as Bar can be removed.
 
 SELECT
     *
 FROM (SELECT 
-      *
-    FROM (
+   det_id,
+   iteration,
+   MIN(det_type) as det_type,
+   MIN(workdir) as workdir,
+   MIN(camera) as camera,
+   MIN(telescope) as telescope,
+   MIN(exp_type) as exp_type,
+   MIN(norm_class_id) as norm_class_id,
+   MIN(fault) as fault,
+   MIN(stack_class_id) as stack_class_id
+  FROM (
         SELECT DISTINCT
             detRun.det_id,