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

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

@@ -17 +17 @@
 FROM
     (SELECT
-        fakeRun.*,
-        rawImfile.class_id as rawimfile_class_id,
-        fakeProcessedImfile.class_id
+        fakeRun.*
+--      These two fields below are not required and cause
+--      trouble with the GROUP BY below 
+--      rawImfile.class_id as rawimfile_class_id,
+--      fakeProcessedImfile.class_id
     FROM fakeRun
     JOIN camRun