Richard Hipp <drh-czdrofg0bjidnm+yrof...@public.gmane.org> writes: > The keys are encoded (see > http://www.sqlite.org/src4/doc/trunk/www/key_encoding.wiki) in a way > that causes a lexicographical ordering of the keys to correspond to > what the user wants out of ORDER BY.
I don't understand why the example entries for values 99.0, 99.01, and 99.0001 have first bytes of 0xb4 and 0xb5, respectively. If we take 99 and use it as "X" in the "2*X+0" formula, shouldn't we wind up with 198, or 0xC6? Likewise, for the second two examples, I'd expect 2*99+1 to yield 199, or 0xC7. (The later entry for 9999 has bytes 0xC7 and 0xC6, which match my expectation.) One more nit: In the paragraph beginning with "If the numeric value is exactly zero," there's an extra "then" which should have been "the" instead: s/then then/then the/ Thank you for documenting all of this. It's ugly for a good reason, which makes it beautiful at the same time. -- Steven E. Harris _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
