diff options
author | Helmut Grohne <helmut@subdivi.de> | 2013-04-08 14:41:23 +0200 |
---|---|---|
committer | Helmut Grohne <helmut@subdivi.de> | 2013-04-08 14:41:23 +0200 |
commit | 37cd7552c36cf5758bbc201e904b02e9b4d0e68a (patch) | |
tree | 981673911070da85ece82fc76fe5a6b88232d204 | |
parent | 75e9759172e956af576cea479b8895963529becb (diff) | |
download | debian-dedup-37cd7552c36cf5758bbc201e904b02e9b4d0e68a.tar.gz |
README: improve query after schemachange
-rw-r--r-- | README | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -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; |