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
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",

Impressum / About Us