Changeset 27680 for trunk/ippTools/share/stacktool_definebyquery_select.sql

Timestamp:

Apr 14, 2010, 12:02:45 PM (16 years ago)

Author:

Paul Price

Message:

Need to group by tess_id to avoid mixing tessellations.

File:

• trunk/ippTools/share/stacktool_definebyquery_select.sql (modified) (4 diffs)

trunk/ippTools/share/stacktool_definebyquery_select.sql

@@ -3 +3 @@
 
 SELECT
+    tess_id,
     skycell_id,
     filter,
-    tess_id,
     num_warp,
     MAX(num_stack) AS num_stack
@@ -11 +11 @@
     -- Number of stack-ready warps as a function of skycell and filter
     SELECT
+        warpSkyfile.tess_id as tess_id,
         skycell_id,
-        warpSkyfile.tess_id as tess_id,
         rawExp.filter,
         COUNT(warpSkyfile.skycell_id) AS num_warp -- number of warps that can be stacked
@@ -28 +28 @@
     -- WHERE hook %s
     GROUP BY
+        warpSkyfile.tess_id,
         skycell_id,
         filter
@@ -45 +46 @@
     ) AS stackSizes
 -- JOINing the warpsToStack and stackSizes tables
-    USING(skycell_id, filter)
+    USING(tess_id, skycell_id, filter)
     )
 GROUP BY
+    tess_id,
     skycell_id,
     filter