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

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

@@ -5 +5 @@
     staticskyRun.label,
     staticskyRun.state,
-    stackRun.tess_id,
-    stackRun.skycell_id,
-    TRUNCATE(skycell.radeg/15., 4) as rahours,
-    skycell.radeg,
-    skycell.decdeg,
-    skycell.glong,
-    skycell.glat,
+    MIN(stackRun.tess_id) as tess_id,
+    MIN(stackRun.skycell_id) as skycell_id,
+    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,  
     staticskyResult.path_base,
     IFNULL(Label.priority, 10000) AS priority