Changeset 29324 for branches/eam_branches/ipp-20100823/ippTools/share/difftool_definestackstack_part1.sql

Timestamp:

Oct 5, 2010, 2:50:18 PM (16 years ago)

Author:

eugene

Message:

add bothways options to warpstack and stackstack (default is bothways = false); add not-bothways option to warpwarp (default is bothways = true); fix stackstack diff query to correctly handle the rerun case with more than one rerun

File:

• branches/eam_branches/ipp-20100823/ippTools/share/difftool_definestackstack_part1.sql (modified) (3 diffs)

branches/eam_branches/ipp-20100823/ippTools/share/difftool_definestackstack_part1.sql

@@ -1 @@
-SELECT 
+SELECT distinct
        stackRun.stack_id,
        stackRun.data_group,
@@ -9 +9 @@
        template.max_stack_id,
        template.template_label,
-       diffExp.diff_id
+       count(diffExp.diff_id) as n_diff
 FROM stackRun JOIN stackSumSkyfile USING(stack_id) 
 JOIN (
@@ -45 +45 @@
         -- diff where hook %s
         -- input where hook again %s
+group by stackRun.stack_id,
+       stackRun.data_group,
+       stackRun.filter,
+       stackRun.label,
+       stackRun.tess_id,
+       stackRun.skycell_id,
+       stackSumSkyfile.good_frac,
+       template.max_stack_id,
+       template.template_label
 ORDER BY stackRun.data_group,stackRun.filter,stackRun.skycell_id