Merge lp:~stub/launchpad/bugsummary into lp:launchpad/db-devel

[Stuart Bishop]

[r=stub][bug=793848] Remove rubbish that happens to be harmess valid SQL

= Summary =

Whoops. Cut and paste error, strangely harmess apart from runtime.

== Proposed fix ==

Cut the crap.

[Stuart Bishop (stub)]

review: Approve (db)

=== modified file 'database/schema/patch-2208-75-0.sql'
--- database/schema/patch-2208-75-0.sql	2011-06-17 06:58:43 +0000
+++ database/schema/patch-2208-75-0.sql	2011-06-17 07:51:22 +0000
@@ -127,87 +127,6 @@
         fixed_upstream, milestone;
 
 
-
-
-
-
-WITH
-    -- kill dupes
-    relevant_bug AS (SELECT * FROM bug where duplicateof is NULL),
-
-    -- (bug.id, tag) for all bug-tag pairs plus (bug.id, NULL) for all bugs
-    bug_tags AS (
-        SELECT relevant_bug.id, NULL::text AS tag FROM relevant_bug
-        UNION
-        SELECT relevant_bug.id, tag
-        FROM relevant_bug INNER JOIN bugtag ON relevant_bug.id=bugtag.bug),
-    -- (bug.id, NULL) for all public bugs + (bug.id, viewer) for all
-    -- (subscribers+assignee) on private bugs
-    bug_viewers AS (
-        SELECT relevant_bug.id, NULL::integer AS person
-        FROM relevant_bug WHERE NOT relevant_bug.private
-        UNION
-        SELECT relevant_bug.id, assignee AS person
-        FROM relevant_bug
-        INNER JOIN bugtask ON relevant_bug.id=bugtask.bug
-        WHERE relevant_bug.private and bugtask.assignee IS NOT NULL
-        UNION
-        SELECT relevant_bug.id, bugsubscription.person
-        FROM relevant_bug INNER JOIN bugsubscription
-            ON bugsubscription.bug=relevant_bug.id WHERE relevant_bug.private),
-
-    fixed_upstream_tasks AS (
-        SELECT BugTask.id, BugTask.bug FROM BugTask
-        WHERE (
-            (bugwatch IS NOT NULL AND status IN (17, 25, 30))
-            OR (
-                bugwatch IS NULL AND product IS NOT NULL
-                AND status IN (25, 30)))),
-
-    -- (bugtask.(bug, product, productseries, distribution, distroseries,
-    -- sourcepackagename, status, milestone) for all bugs + the same with
-    -- sourcepackage squashed to NULL)
-    tasks AS (
-        SELECT
-            bug, product, productseries, distribution, distroseries,
-            sourcepackagename, status, milestone, importance,
-            EXISTS (
-                SELECT TRUE FROM fixed_upstream_tasks
-                WHERE 
-                    BugTask.bug = fixed_upstream_tasks.bug
-                    AND BugTask.id <> fixed_upstream_tasks.id
-                    ) AS fixed_upstream
-        FROM bugtask
-        UNION
-        SELECT DISTINCT ON (
-            bug, product, productseries, distribution, distroseries,
-            sourcepackagename, milestone)
-            bug, product, productseries, distribution, distroseries,
-            NULL::integer as sourcepackagename,
-            status, milestone, importance,
-            EXISTS (
-                SELECT TRUE FROM fixed_upstream_tasks
-                WHERE
-                    BugTask.bug = fixed_upstream_tasks.bug
-                    AND BugTask.id <> fixed_upstream_tasks.id
-                    ) AS fixed_upstream
-        FROM bugtask where sourcepackagename IS NOT NULL)
-
-    -- Now combine
-    SELECT
-        count(*), product, productseries, distribution, distroseries,
-        sourcepackagename, person, tag, status, milestone, importance,
-        latest_patch_uploaded IS NOT NULL AS has_patch, fixed_upstream
-    FROM relevant_bug
-    INNER JOIN bug_tags ON relevant_bug.id=bug_tags.id
-    INNER JOIN bug_viewers ON relevant_bug.id=bug_viewers.id
-    INNER JOIN tasks on tasks.bug=relevant_bug.id
-    GROUP BY
-        product, productseries, distribution, distroseries,
-        sourcepackagename, person, tag, status, milestone,
-        importance, has_patch, fixed_upstream;
-
-
 -- Rebuild indexes.
 CREATE INDEX bugsummary__full__idx ON BugSummary (
     tag, status, product, productseries, distribution,