mattn/go-sqlite3

Adding SHA3 extension to the built library

jamietanna opened this issue · 0 comments

When trying to run a query such as:

-- name: AnonymiseOrgAndRepo :exec
update renovate
set
  organisation  = 'ANON-' || hex(sha3(organisation)),
  repo          = 'ANON-' || hex(sha3(repo))
where
  organisation
    NOT LIKE 'ANON-%'
  OR
  repo
    NOT LIKE 'ANON-%'
;

This results in

Error: no such function: sha3

Looking at a similar discussion in the SQLite forum, this is an extension that I appear to have enabled in my sqlite3 binary but that may not be enabled by default here.