summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorHelmut Grohne <helmut@subdivi.de>2013-07-23 23:26:52 +0200
committerHelmut Grohne <helmut@subdivi.de>2013-07-23 23:26:52 +0200
commit1e50900862fe8887755597d85483dbc845ccb5e3 (patch)
tree88f744e66b68ac16efb51b20dbf0d8b358aa32ff
parentda33f7f323fa9431809e4d93a546e3b234d50406 (diff)
downloaddebian-dedup-1e50900862fe8887755597d85483dbc845ccb5e3.tar.gz
README: fix typo in query
-rw-r--r--README2
1 files changed, 1 insertions, 1 deletions
diff --git a/README b/README
index 44b086a..a023d0a 100644
--- a/README
+++ b/README
@@ -38,7 +38,7 @@ SQL database by hand. Here are some example queries.
Finding the 100 largest files shared with multiple packages.
- SELECT pa.name, a.filename, pb.name, b.filename, a.size FROM content AS a JOIN hash AS ha ON a.id = ha.cid JOIN hash AS hb ON ha.hash = hb.hash JOIN content AS b ON b.id = hb.cid JOIN package AS pa ON b.pid = pa.id JOIN package AS pb ON b.pid = pb.id WHERE (a.pid != b.pid OR a.filename != b.filename) ORDER BY a.size DESC LIMIT 100;
+ SELECT pa.name, a.filename, pb.name, b.filename, a.size FROM content AS a JOIN hash AS ha ON a.id = ha.cid JOIN hash AS hb ON ha.hash = hb.hash JOIN content AS b ON b.id = hb.cid JOIN package AS pa ON a.pid = pa.id JOIN package AS pb ON b.pid = pb.id WHERE (a.pid != b.pid OR a.filename != b.filename) ORDER BY a.size DESC LIMIT 100;
Finding those top 100 files that save most space when being reduced to only
one copy in the archive.