Changeset 42579 for branches/eam_branches/ipp-20230313/ippTools/share/xcskytool_result.sql

Timestamp:

Jan 10, 2024, 12:37:20 PM (3 years ago)

Author:

eugene

Message:

fix xcskytools mysql code (support for mysql >5.7.5)

File:

• branches/eam_branches/ipp-20230313/ippTools/share/xcskytool_result.sql (modified) (1 diff)

branches/eam_branches/ipp-20230313/ippTools/share/xcskytool_result.sql

@@ -4 +4 @@
     xcskyRun.workdir,
     xcskyRun.label,
-    xcstackRun.tess_id,
-    xcstackRun.skycell_id,
+    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 
     count(xcstackRun.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 xcskyRun
 JOIN xcskyResult USING(xcsky_id)