summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorHelmut Grohne <helmut@subdivi.de>2013-07-03 21:49:04 +0200
committerHelmut Grohne <helmut@subdivi.de>2013-07-03 21:49:04 +0200
commitc0b3911602064bb303172c547bf7491b1e34afd3 (patch)
tree5497f6afa0ff2994f0fb02cb5ce91f9c4aa1255c
parent56d048320a358b2c417cdb2211b3640394a182e9 (diff)
downloaddebian-dedup-c0b3911602064bb303172c547bf7491b1e34afd3.tar.gz
README: fix example query for hash BLOBsblobhash
Otherwise the sqlite tool just outputs them as binary to the terminal.
-rw-r--r--README2
1 files changed, 1 insertions, 1 deletions
diff --git a/README b/README
index a5ce9d7..c21a50c 100644
--- a/README
+++ b/README
@@ -39,7 +39,7 @@ Finding the 100 largest files shared with multiple packages.
Finding those top 100 files that save most space when being reduced to only
one copy in the archive.
- SELECT hash, sum(size)-min(size), count(*), count(distinct package) FROM content JOIN hash ON content.id = hash.cid WHERE hash.function = "sha512" GROUP BY hash ORDER BY sum(size)-min(size) DESC LIMIT 100;
+ SELECT quote(hash), sum(size)-min(size), count(*), count(distinct package) FROM content JOIN hash ON content.id = hash.cid WHERE hash.function = "sha512" GROUP BY hash ORDER BY sum(size)-min(size) DESC LIMIT 100;
Finding PNG images that do not carry a .png file extension.