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

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

@@ -1 +1 @@
 SELECT
-    xcskyResult.*,
-    xcskyRun.state,
-    xcskyRun.workdir,
-    xcskyRun.label,
+    -- EAM only return values needed by supporting code
+    -- this query is used in dist_advancerun.pl & permcheck.pl
+    -- needed fields: workdir, skycell_id, path_base 
+    MIN(xcskyResult.path_base) AS path_base,
+    MIN(xcskyRun.state) AS state,
+    MIN(xcskyRun.workdir) as workdir,
+    MIN(xcskyRun.label) as label,
     MIN(xcstackRun.tess_id) as tess_id, -- we implicitly assume that all xcstackRuns used for a xcskyRun have the same tess_id
     MIN(xcstackRun.skycell_id) as skycell_id, -- and skycell_id