summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorHelmut Grohne <helmut@subdivi.de>2013-04-08 14:41:23 +0200
committerHelmut Grohne <helmut@subdivi.de>2013-04-08 14:41:23 +0200
commit37cd7552c36cf5758bbc201e904b02e9b4d0e68a (patch)
tree981673911070da85ece82fc76fe5a6b88232d204
parent75e9759172e956af576cea479b8895963529becb (diff)
downloaddebian-dedup-37cd7552c36cf5758bbc201e904b02e9b4d0e68a.tar.gz
README: improve query after schemachange
-rw-r--r--README2
1 files changed, 1 insertions, 1 deletions
diff --git a/README b/README
index 55a8eb6..2d362f9 100644
--- a/README
+++ b/README
@@ -43,4 +43,4 @@ Finding PNG images that do not carry a .png file extension.
Finding .gz files which either are not gziped or contain errors.
- SELECT a.package, a.filename FROM content AS a JOIN hash AS ha ON a.id = ha.cid WHERE ha.function = "sha512" AND a.filename LIKE "%.gz" AND (SELECT count(*) FROM content AS b JOIN hash AS hb ON b.id = hb.cid WHERE b.package = a.package AND b.filename = a.filename AND hb.function = "gzip_sha512") = 0;
+ SELECT content.package, content.filename FROM content WHERE filename LIKE "%.gz" AND (SELECT count(*) FROM hash WHERE hash.cid = content.id AND hash.function = "gzip_sha512") = 0;