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

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

@@ -3 +3 @@
         Label.label AS label_label,
         IFNULL(Label.priority, 10000) AS priority,
-        count(warpRun.warp_id)
+        count(warpRun.warp_id) AS N_warp
     FROM warpRun
     LEFT JOIN Label ON warpRun.label = Label.label
@@ -11 +11 @@
         -- where hook %s
         group by warpRun.label
-        ORDER BY priority DESC, warp_id
+        ORDER BY priority DESC, N_warp DESC
+--      The old query had warp_id below which is nonsensical
+--      ORDER BY priority DESC, warp_id