explain what can be done with the new dataconflicts

1 files changed, 4 insertions, 0 deletions

diff --git a/README b/README
index bf4da52..346fa5d 100644
--- a/README
+++ b/README
@@ -52,3 +52,7 @@ Finding PNG images that do not carry a .png file extension.
 Finding .gz files which either are not gziped or contain errors.
 
     SELECT package.name, content.filename FROM content JOIN package ON content.pid = package.id WHERE filename LIKE "%.gz" AND (SELECT count(*) FROM hash JOIN function ON hash.fid = function.id WHERE hash.cid = content.id AND function.name = "gzip_sha512") = 0;
+
+Finding undeclared file conflicts.
+
+    SELECT pa.name, ca.filename, pb.name, cb.filename FROM content AS ca JOIN content AS cb ON ca.filename = cb.filename JOIN package AS pa ON ca.pid = pa.id JOIN package AS pb ON cb.pid = pb.id WHERE ca.id != cb.id AND NOT EXISTS (SELECT 1 FROM conflict WHERE conflict.pid = pa.id AND (conflict.conflicting = pb.name OR conflict.conflicting = "_dpkg-divert")) AND NOT EXISTS (SELECT 1 FROM conflict WHERE conflict.pid = pb.id AND (conflict.conflicting = pa.name or conflict.conflicting = "_dpkg-divert")) AND NOT EXISTS (SELECT 1 FROM conflict JOIN provide ON provide.provided = conflict.conflicting WHERE (provide.pid = pa.id AND conflict.pid = pb.id) OR (provide.pid = pb.id AND conflict.pid = pa.id));