Changeset 18579 for trunk/ippTools/share

Timestamp:

Jul 16, 2008, 1:01:47 PM (18 years ago)

Author:

Paul Price

Message:

Fixing buggy query to get list of warps and stacks. It would return a row for every stack that exists, rather than a row for every skycell/filter combination. Completely re-crafted the query so that it returns a single row for each skycell/filter combination, with the number of warps available to be stacked and the number of warps in the biggest stack. It's a bit complicated, and I'm not entirely sure it's 100% correct, but it seems to work on the simtest (though that's only a single skycell).

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• stacktool_definebyquery_groupby.sql (deleted)
• stacktool_definebyquery_part1.sql (added)
• stacktool_definebyquery_part2.sql (added)
• stacktool_definebyquery_select.sql (deleted)
• stacktool_definebyquery_test.sql (added)

trunk/ippTools/share/Makefile.am

@@ -108 +108 @@
         regtool_revertprocessedexp.sql \
         regtool_revertprocessedimfile.sql \
-        stacktool_definebyquery_select.sql \
-        stacktool_definebyquery_groupby.sql \
+        stacktool_definebyquery_part1.sql \
+        stacktool_definebyquery_part2.sql \
         stacktool_definebyquery_insert.sql \
         stacktool_definebyquery_insert_random.sql \