liquid_feedback_core

changeset 480:bae6d7c89f97

Removed wrong "ISNULL" in view "updated_initiative"
author jbe
date Fri Apr 01 16:57:59 2016 +0200 (2016-04-01)
parents 8ded0e66a542
children 698559ebe9cd
files core.sql update/core-update.v3.1.0-v3.2.0.sql
line diff
     1.1 --- a/core.sql	Fri Apr 01 16:42:04 2016 +0200
     1.2 +++ b/core.sql	Fri Apr 01 16:57:59 2016 +0200
     1.3 @@ -2412,7 +2412,7 @@
     1.4    JOIN "supporter" ON
     1.5      "supporter"."member_id" = "member"."id" AND
     1.6      "supporter"."initiative_id" = "initiative"."id"
     1.7 -  WHERE "issue"."state" IN ('admission', 'discussion') ISNULL
     1.8 +  WHERE "issue"."state" IN ('admission', 'discussion')
     1.9    AND (
    1.10      EXISTS (
    1.11        SELECT NULL FROM "draft"
     2.1 --- a/update/core-update.v3.1.0-v3.2.0.sql	Fri Apr 01 16:42:04 2016 +0200
     2.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql	Fri Apr 01 16:57:59 2016 +0200
     2.3 @@ -55,7 +55,7 @@
     2.4    JOIN "supporter" ON
     2.5      "supporter"."member_id" = "member"."id" AND
     2.6      "supporter"."initiative_id" = "initiative"."id"
     2.7 -  WHERE "issue"."state" IN ('admission', 'discussion') ISNULL
     2.8 +  WHERE "issue"."state" IN ('admission', 'discussion')
     2.9    AND (
    2.10      EXISTS (
    2.11        SELECT NULL FROM "draft"

Impressum / About Us