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

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

@@ -1 +1 @@
 SELECT
-    staticskyResult.*,
-    staticskyRun.state,
-    staticskyRun.workdir,
-    staticskyRun.label,
-    stackRun.tess_id,
-    stackRun.skycell_id,
+    -- 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(staticskyResult.path_base) AS path_base,
+    MIN(staticskyRun.state) AS state,
+    MIN(staticskyRun.workdir) AS workdir,
+    MIN(staticskyRun.label) AS label,
+    MIN(stackRun.tess_id) AS tess_id,
+    MIN(stackRun.skycell_id) AS skycell_id,
     count(stackRun.filter) AS num_filters,
-    TRUNCATE(skycell.radeg/15., 4) AS rahours,
-    skycell.radeg,
-    skycell.decdeg,
-    skycell.glong,
-    skycell.glat
+    TRUNCATE(MIN(skycell.radeg)/15., 4) AS rahours,
+    MIN(skycell.radeg) AS radeg,
+    MIN(skycell.decdeg) AS decdeg,
+    MIN(skycell.glong) AS glong,
+    MIN(skycell.glat) AS glat
 FROM staticskyRun
 JOIN staticskyResult USING(sky_id)