summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-12-28 17:22:11 +0100
committerYorhel <git@yorhel.nl>2009-12-28 17:22:11 +0100
commit31508415ce5eb6cd5c3de48a60e8a211dea22803 (patch)
treec24b9e8e0f45a94ba43e5e57fe60904fc7a8f498 /util
parent0047ec5695bb7fa38608d380f0ccb24099b7ce82 (diff)
SQL: Fixed bug in producer_relgraph_notify()
Diffstat (limited to 'util')
-rw-r--r--util/dump.sql7
-rw-r--r--util/updates/update_2.10.sql7
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)