# HG changeset patch
# User jbe
# Date 1459522679 -7200
# Node ID bae6d7c89f97519a8959bd6fe1b7c5a58aed6e5f
# Parent  8ded0e66a54211621ecec5265b952139223e62f0
Removed wrong "ISNULL" in view "updated_initiative"

diff -r 8ded0e66a542 -r bae6d7c89f97 core.sql
--- a/core.sql	Fri Apr 01 16:42:04 2016 +0200
+++ b/core.sql	Fri Apr 01 16:57:59 2016 +0200
@@ -2412,7 +2412,7 @@
   JOIN "supporter" ON
     "supporter"."member_id" = "member"."id" AND
     "supporter"."initiative_id" = "initiative"."id"
-  WHERE "issue"."state" IN ('admission', 'discussion') ISNULL
+  WHERE "issue"."state" IN ('admission', 'discussion')
   AND (
     EXISTS (
       SELECT NULL FROM "draft"
diff -r 8ded0e66a542 -r bae6d7c89f97 update/core-update.v3.1.0-v3.2.0.sql
--- a/update/core-update.v3.1.0-v3.2.0.sql	Fri Apr 01 16:42:04 2016 +0200
+++ b/update/core-update.v3.1.0-v3.2.0.sql	Fri Apr 01 16:57:59 2016 +0200
@@ -55,7 +55,7 @@
   JOIN "supporter" ON
     "supporter"."member_id" = "member"."id" AND
     "supporter"."initiative_id" = "initiative"."id"
-  WHERE "issue"."state" IN ('admission', 'discussion') ISNULL
+  WHERE "issue"."state" IN ('admission', 'discussion')
   AND (
     EXISTS (
       SELECT NULL FROM "draft"