diff options
| author | Yorhel <git@yorhel.nl> | 2009-12-28 17:22:11 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2009-12-28 17:22:11 +0100 |
| commit | 31508415ce5eb6cd5c3de48a60e8a211dea22803 (patch) | |
| tree | c24b9e8e0f45a94ba43e5e57fe60904fc7a8f498 | |
| parent | 0047ec5695bb7fa38608d380f0ccb24099b7ce82 (diff) | |
SQL: Fixed bug in producer_relgraph_notify()
| -rw-r--r-- | util/dump.sql | 7 | ||||
| -rw-r--r-- | 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) |