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"