# HG changeset patch
# User jbe
# Date 1306974790 -7200
# Node ID dca335a33e0b7e8ec40f27e40394c6f23d8e7457
# Parent  a426ce0124a299226d768d9661ef70bde749790b
Bugfix in function "clean_issue": Temporarily update "issue"."state" to avoid constraint violation

diff -r a426ce0124a2 -r dca335a33e0b core.sql
--- a/core.sql	Thu Jun 02 02:16:11 2011 +0200
+++ b/core.sql	Thu Jun 02 02:33:10 2011 +0200
@@ -4035,9 +4035,9 @@
         FROM "issue" WHERE "id" = "issue_id_p"
         FOR UPDATE;
       IF "issue_row"."cleaned" ISNULL THEN
-        -- TODO: might be broken due to new constraints!
         UPDATE "issue" SET
-          "closed" = NULL,
+          "state"           = 'voting',
+          "closed"          = NULL,
           "ranks_available" = FALSE
           WHERE "id" = "issue_id_p";
         DELETE FROM "delegating_voter"
@@ -4059,6 +4059,7 @@
         DELETE FROM "supporter"
           WHERE "issue_id" = "issue_id_p";
         UPDATE "issue" SET
+          "state"           = "issue_row"."state",
           "closed"          = "issue_row"."closed",
           "ranks_available" = "issue_row"."ranks_available",
           "cleaned"         = now()