liquid_feedback_core
diff core.sql @ 582:225a0c047691
Bugfix in function "write_event_initiative_revoked_trigger" (wrong use of SELECT, needs to be PERFORM)
author | jbe |
---|---|
date | Tue Sep 04 14:30:41 2018 +0200 (2018-09-04) |
parents | 1cb6710fc429 |
children | f5095a9696eb |
line diff
1.1 --- a/core.sql Sun Mar 04 18:10:07 2018 +0100 1.2 +++ b/core.sql Tue Sep 04 14:30:41 2018 +0200 1.3 @@ -1999,13 +1999,13 @@ 1.4 BEGIN 1.5 IF OLD."revoked" ISNULL AND NEW."revoked" NOTNULL THEN 1.6 -- NOTE: lock for primary key update to avoid new drafts 1.7 - SELECT NULL FROM "initiative" WHERE "id" = NEW."id" FOR UPDATE; 1.8 + PERFORM NULL FROM "initiative" WHERE "id" = NEW."id" FOR UPDATE; 1.9 SELECT * INTO "issue_row" FROM "issue" 1.10 WHERE "id" = NEW."issue_id" FOR SHARE; 1.11 SELECT * INTO "area_row" FROM "area" 1.12 WHERE "id" = "issue_row"."area_id" FOR SHARE; 1.13 -- NOTE: FOR SHARE cannot be used with DISTINCT in view "current_draft" 1.14 - SELECT NULL FROM "draft" WHERE "initiative_id" = NEW."id" FOR SHARE; 1.15 + PERFORM NULL FROM "draft" WHERE "initiative_id" = NEW."id" FOR SHARE; 1.16 SELECT "id" INTO "draft_id_v" FROM "current_draft" 1.17 WHERE "initiative_id" = NEW."id"; 1.18 INSERT INTO "event" (