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

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

@@ -1 @@
-SELECT sass_id,camera,workdir,tess_id,state FROM 
-(SELECT sass_id,rawExp.camera,stackRun.workdir,stackRun.tess_id,stackRun.state,
-       sum((stackRun.state = 'full')) AS is_done, sum(1) AS is_defined
+SELECT
+  sass_id,
+  camera,
+  workdir,
+  tess_id,
+  state
+FROM 
+(SELECT sass_id,
+        MIN(rawExp.camera)    AS camera,
+        MIN(stackRun.workdir) AS workdir,
+        MIN(stackRun.tess_id) AS tess_id,
+        MIN(stackRun.state)   AS state,
+        SUM((stackRun.state = 'full')) AS is_done,
+        SUM(1) AS is_defined
        FROM stackRun
        JOIN stackInputSkyfile ON stackRun.stack_id = stackInputSkyfile.stack_id