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

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

@@ -1 +1 @@
 SELECT DISTINCT
     pstampDependent.*,
-    pstampRequest.label,
+    MIN(pstampRequest.label) as label,
     MIN(req_id) as first_req_id,
     concat( pstampDependent.outdir, '/checkdep.', dep_id, '.log') as logfile,
-    IFNULL(Label.priority, 10000) AS priority
+    MIN(IFNULL(Label.priority, 10000)) AS priority
 FROM pstampDependent
 JOIN pstampJob USING(dep_id)
@@ -13 +13 @@
     AND pstampRequest.state = 'run'
     AND (Label.active OR Label.active IS NULL)
+-- EAM TEST:
+-- this is added in pstamptool, but is needed to test the SQL validity
+-- GROUP BY dep_id ORDER BY priority DESC, MIN(req_id), dep_id
+