Changeset 42597 for branches/eam_branches/ipp-20230313/ippTools/share

Timestamp:

Jan 20, 2024, 10:44:12 AM (3 years ago)

Author:

eugene

Message:

all of the xcfftool modes seem to work at the basic table-interaction level

Location:

branches/eam_branches/ipp-20230313/ippTools/share

Files:

• xcfftool_summary.sql (modified) (1 diff)
• xcfftool_toadvance.sql (modified) (1 diff)

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

@@ -9 +9 @@
     xcForceRun.tess_id,
     xcForceRun.skycell_id,
-    'summary' AS dist_component,
+    'summary' AS dist_component
 FROM xcForceRun
     JOIN xcForceSummary USING(xcff_id)

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

@@ -9 +9 @@
     LEFT JOIN xcForceResult USING(xcff_id, warp_id)
     LEFT JOIN xcForceSummary USING(xcff_id)
-WHERE xcForceRun.state = 'new' AND xcForceSummary.ff_id IS NULL
+WHERE xcForceRun.state = 'new' AND xcForceSummary.xcff_id IS NULL
     -- WHERE hook %s
     GROUP BY xcff_id