I found an assertion failure while SQLite (latest, 3e9c9bbdb59b9d50) executes the following queries.

Here is the link to file test.db used for reproducing the crash: test.db

.open test.db
SELECT zipfile(@0) ORDER BY 1;

Here are the outputs:

sqlite3-asan: sqlite3.c:95181: int sqlite3VdbeExec(Vdbe *): Assertion `pCx->pKeyInfo->enc==ENC(db)' failed.

My compilation flags:

    export CFLAGS="-g -O0 -DSQLITE_DEBUG 
                -DSQLITE_ENABLE_TREETRACE 
                -DSQLITE_ENABLE_WHERETRACE
                -DSQLITE_ENABLE_CURSOR_HINTS 
                -DSQLITE_COUNTOFVIEW_OPTIMIZATION 
                -DSQLITE_ENABLE_STAT4"