diff options
| -rw-r--r-- | README | 4 |
1 files changed, 4 insertions, 0 deletions
@@ -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)); |