From 31508415ce5eb6cd5c3de48a60e8a211dea22803 Mon Sep 17 00:00:00 2001 From: Yorhel Date: Mon, 28 Dec 2009 17:22:11 +0100 Subject: SQL: Fixed bug in producer_relgraph_notify() --- util/dump.sql | 7 ++----- util/updates/update_2.10.sql | 7 ++----- 2 files changed, 4 insertions(+), 10 deletions(-) diff --git a/util/dump.sql b/util/dump.sql index 66db690c..4c6a4648 100644 --- a/util/dump.sql +++ b/util/dump.sql @@ -708,11 +708,8 @@ BEGIN END IF; END IF; IF NEW.rgraph IS NOT NULL THEN - IF - -- 2. - OLD.c_released IS DISTINCT FROM NEW.c_released - OR OLD.c_languages IS DISTINCT FROM NEW.c_languages - OR OLD.latest <> 0 AND OLD.latest IS DISTINCT FROM NEW.latest AND ( + -- 2. + IF OLD.latest <> 0 AND OLD.latest IS DISTINCT FROM NEW.latest AND ( -- 3. EXISTS(SELECT 1 FROM producers_rev p1, producers_rev p2 WHERE (p2.name <> p1.name OR p2.type <> p1.type OR p2.lang <> p1.lang) AND p1.id = OLD.latest AND p2.id = NEW.latest) -- 4. (not-really-readable method of comparing two query results) diff --git a/util/updates/update_2.10.sql b/util/updates/update_2.10.sql index ad2dd1c7..47a05ac5 100644 --- a/util/updates/update_2.10.sql +++ b/util/updates/update_2.10.sql @@ -101,11 +101,8 @@ BEGIN END IF; END IF; IF NEW.rgraph IS NOT NULL THEN - IF - -- 2. - OLD.c_released IS DISTINCT FROM NEW.c_released - OR OLD.c_languages IS DISTINCT FROM NEW.c_languages - OR OLD.latest <> 0 AND OLD.latest IS DISTINCT FROM NEW.latest AND ( + -- 2. + IF OLD.latest <> 0 AND OLD.latest IS DISTINCT FROM NEW.latest AND ( -- 3. EXISTS(SELECT 1 FROM producers_rev p1, producers_rev p2 WHERE (p2.name <> p1.name OR p2.type <> p1.type OR p2.lang <> p1.lang) AND p1.id = OLD.latest AND p2.id = NEW.latest) -- 4. (not-really-readable method of comparing two query results) -- cgit v1.2.3