diff options
author | Helmut Grohne <helmut@subdivi.de> | 2013-07-03 21:49:04 +0200 |
---|---|---|
committer | Helmut Grohne <helmut@subdivi.de> | 2013-07-03 21:49:04 +0200 |
commit | c0b3911602064bb303172c547bf7491b1e34afd3 (patch) | |
tree | 5497f6afa0ff2994f0fb02cb5ce91f9c4aa1255c | |
parent | 56d048320a358b2c417cdb2211b3640394a182e9 (diff) | |
download | debian-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-- | README | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -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. |