Changeset 41681 for trunk/ippTools/share

Timestamp:

Jul 2, 2021, 8:35:25 AM (5 years ago)

Author:

eugene

Message:

allow cross-filter stack-stack diffs with -relaxed-filters

Location:

trunk/ippTools/share

Files:

• difftool_definestackstack_part0.sql (modified) (1 diff)
• difftool_definestackstack_part1.sql (modified) (1 diff)

trunk/ippTools/share/difftool_definestackstack_part0.sql

@@ -26 +26 @@
            skycell_id,
            filter
-) AS template ON stackRun.filter = template.filter 
-              AND stackRun.tess_id = template.tess_id 
-              AND stackRun.skycell_id = template.skycell_id 
+) AS template ON stackRun.tess_id = template.tess_id 
+              AND stackRun.skycell_id = template.skycell_id 
+              @FILT0_QUERY@  -- include filter constraint if requested
 LEFT JOIN (
      SELECT 

trunk/ippTools/share/difftool_definestackstack_part1.sql

@@ -27 +27 @@
            skycell_id,
            filter
-) AS template ON stackRun.filter = template.filter 
-              AND stackRun.tess_id = template.tess_id 
+) AS template ON stackRun.tess_id = template.tess_id 
               AND stackRun.skycell_id = template.skycell_id 
+              @FILT1_QUERY@  -- include filter constraint if requested
 LEFT JOIN (
      SELECT