liquid_feedback_core
diff core.sql @ 17:1cba764373d6
Version beta18
Bug fixed, which caused issue_voting_started events in timeline to be shown only after an issue had been closed
Bug fixed, which caused issue_voting_started events in timeline to be shown only after an issue had been closed
author | jbe |
---|---|
date | Sat Jan 23 12:00:00 2010 +0100 (2010-01-23) |
parents | 359d2b311f2c |
children | 549b1a0fc042 |
line diff
1.1 --- a/core.sql Fri Jan 22 12:00:00 2010 +0100 1.2 +++ b/core.sql Sat Jan 23 12:00:00 2010 +0100 1.3 @@ -6,7 +6,7 @@ 1.4 BEGIN; 1.5 1.6 CREATE VIEW "liquid_feedback_version" AS 1.7 - SELECT * FROM (VALUES ('beta17', NULL, NULL, NULL)) 1.8 + SELECT * FROM (VALUES ('beta18', NULL, NULL, NULL)) 1.9 AS "subquery"("string", "major", "minor", "revision"); 1.10 1.11 1.12 @@ -1416,7 +1416,8 @@ 1.13 'issue_voting_started'::"timeline_event" AS "event", 1.14 "id" AS "issue_id" 1.15 FROM "issue" 1.16 - WHERE "fully_frozen" NOTNULL AND "closed" != "fully_frozen" 1.17 + WHERE "fully_frozen" NOTNULL 1.18 + AND ("closed" ISNULL OR "closed" != "fully_frozen") 1.19 UNION ALL 1.20 SELECT 1.21 "closed" AS "occurrence",