From 37cd7552c36cf5758bbc201e904b02e9b4d0e68a Mon Sep 17 00:00:00 2001 From: Helmut Grohne Date: Mon, 8 Apr 2013 14:41:23 +0200 Subject: README: improve query after schemachange --- README | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'README') 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; -- cgit v1.2.3