Thus said Stephan Beal on Thu, 18 Dec 2014 22:29:27 +0100: > The goal is for it to output: > > a) an "N" value (prefix length) > b) a uuid prefix N bytes long > c) the number of collisions for that prefix. > > Does the following SQL actually do that?
I ran the query locally and got the same results. Based on the output it would seem to meet the goal. Nice! That would have taken me quite some time in SQL to figure out. > ) SELECT > nn.n as n, > substr(blob.uuid,1,n) as part, This is nifty. Thanks for sharing. Andy -- TAI64 timestamp: 400000005493bcee _______________________________________________ fossil-dev mailing list fossil-dev@lists.fossil-scm.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/fossil-dev
