From 85f1ad4cefe5ac3e3c0ff9f05d8da4a9c20d9812 Mon Sep 17 00:00:00 2001 From: Yorhel Date: Wed, 10 Nov 2010 21:47:54 +0100 Subject: Multi::RG: Use dotted line to indicate unofficial status in VN relations Also fixed a minor bug with no change notification being sent to Multi when only the official flag has been changed. --- util/sql/func.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'util') diff --git a/util/sql/func.sql b/util/sql/func.sql index 922d1af8..371e3ed0 100644 --- a/util/sql/func.sql +++ b/util/sql/func.sql @@ -496,7 +496,7 @@ BEGIN -- 3. EXISTS(SELECT 1 FROM vn_rev v1, vn_rev v2 WHERE v2.title <> v1.title AND v1.id = OLD.latest AND v2.id = NEW.latest) -- 4. (not-really-readable method of comparing two query results) - OR EXISTS(SELECT vid2, relation FROM vn_relations WHERE vid1 = OLD.latest EXCEPT SELECT vid2, relation FROM vn_relations WHERE vid1 = NEW.latest) + OR EXISTS(SELECT vid2, relation, official FROM vn_relations WHERE vid1 = OLD.latest EXCEPT SELECT vid2, relation, official FROM vn_relations WHERE vid1 = NEW.latest) OR (SELECT COUNT(*) FROM vn_relations WHERE vid1 = OLD.latest) <> (SELECT COUNT(*) FROM vn_relations WHERE vid1 = NEW.latest) ) THEN -- cgit v1.2.3