# HG changeset patch
# User jbe
# Date 1264244400 -3600
# Node ID 1cba764373d68f168bf2a6710440ad9fac7a2f8b
# Parent  359d2b311f2ce96901448b06fb4c5a314f9004d8
Version beta18

Bug fixed, which caused issue_voting_started events in timeline to be shown only after an issue had been closed

diff -r 359d2b311f2c -r 1cba764373d6 core-update.beta17-beta18.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/core-update.beta17-beta18.sql	Sat Jan 23 12:00:00 2010 +0100
@@ -0,0 +1,50 @@
+BEGIN;
+
+CREATE OR REPLACE VIEW "liquid_feedback_version" AS
+  SELECT * FROM (VALUES ('beta18', NULL, NULL, NULL))
+  AS "subquery"("string", "major", "minor", "revision");
+
+CREATE OR REPLACE VIEW "timeline_issue" AS
+    SELECT
+      "created" AS "occurrence",
+      'issue_created'::"timeline_event" AS "event",
+      "id" AS "issue_id"
+    FROM "issue"
+  UNION ALL
+    SELECT
+      "closed" AS "occurrence",
+      'issue_canceled'::"timeline_event" AS "event",
+      "id" AS "issue_id"
+    FROM "issue" WHERE "closed" NOTNULL AND "fully_frozen" ISNULL
+  UNION ALL
+    SELECT
+      "accepted" AS "occurrence",
+      'issue_accepted'::"timeline_event" AS "event",
+      "id" AS "issue_id"
+    FROM "issue" WHERE "accepted" NOTNULL
+  UNION ALL
+    SELECT
+      "half_frozen" AS "occurrence",
+      'issue_half_frozen'::"timeline_event" AS "event",
+      "id" AS "issue_id"
+    FROM "issue" WHERE "half_frozen" NOTNULL
+  UNION ALL
+    SELECT
+      "fully_frozen" AS "occurrence",
+      'issue_voting_started'::"timeline_event" AS "event",
+      "id" AS "issue_id"
+    FROM "issue"
+    WHERE "fully_frozen" NOTNULL
+    AND ("closed" ISNULL OR "closed" != "fully_frozen")
+  UNION ALL
+    SELECT
+      "closed" AS "occurrence",
+      CASE WHEN "fully_frozen" = "closed" THEN
+        'issue_finished_without_voting'::"timeline_event"
+      ELSE
+        'issue_finished_after_voting'::"timeline_event"
+      END AS "event",
+      "id" AS "issue_id"
+    FROM "issue" WHERE "closed" NOTNULL AND "fully_frozen" NOTNULL;
+
+COMMIT;
diff -r 359d2b311f2c -r 1cba764373d6 core.sql
--- a/core.sql	Fri Jan 22 12:00:00 2010 +0100
+++ b/core.sql	Sat Jan 23 12:00:00 2010 +0100
@@ -6,7 +6,7 @@
 BEGIN;
 
 CREATE VIEW "liquid_feedback_version" AS
-  SELECT * FROM (VALUES ('beta17', NULL, NULL, NULL))
+  SELECT * FROM (VALUES ('beta18', NULL, NULL, NULL))
   AS "subquery"("string", "major", "minor", "revision");
 
 
@@ -1416,7 +1416,8 @@
       'issue_voting_started'::"timeline_event" AS "event",
       "id" AS "issue_id"
     FROM "issue"
-    WHERE "fully_frozen" NOTNULL AND "closed" != "fully_frozen"
+    WHERE "fully_frozen" NOTNULL
+    AND ("closed" ISNULL OR "closed" != "fully_frozen")
   UNION ALL
     SELECT
       "closed" AS "occurrence",