I had a look at ext/misc/sqlar.c
<https://www.sqlite.org/src/finfo?name=ext/misc/sqlar.c&m=57d5bc45cd549220>
and, in spite of not being a programmer, I think I understand the sqlar
functions a bit better.
- sqlar_compress(X) wants X to be a blob. Say it compresses X to Y,
- sqlar_uncompress(Y, SZ) needs SZ =length(X) to uncompress Y back to X,
else it returns Y
Tom
On Fri, Mar 1, 2019 at 2:37 PM Tom Holden <ve3meo@xxxxxxxxx> wrote:
2. sqlar extension adds SQLAR_COMPRESS() and SQLAR_UNCOMPRESS(), but:
- SELECT SQLAR_COMPRESS(*something*) returns *something*, unchanged
- *SELECT SQLAR_ UNCOMPRESS( SQLAR_ COMPRESS(something)) returns an
error 1 "wrong number of arguments to function sqlar_uncompress()" *