SQLite Forum

zeroblob64 and errcode

zeroblob64 and errcode

(1) By ddevienne on 2020-09-23 12:58:44

My call to `sqlite3_bind_zeroblob64()` fails with SQLITE_TOOBIG,  
yet `sqlite3_errmsg()` returns *"not an error"*. And I am calling  
`sqlite3_errcode()` and `sqlite3_errmsg()` right after than *too big* error.

A quick look at the code, seems to confirm this API does not set  
`db->errCode` like other binds do, via `vdbeUnbind()`. This seems to  
violate the contract of <https://www.sqlite.org/c3ref/errcode.html>:

> If the most recent sqlite3_* API call associated with database  
> connection D failed, then the sqlite3_errcode(D) interface returns  
> the numeric result code or extended result code for that API call.

Simple oversight? Thanks, --DD

(2) By Richard Hipp (drh) on 2021-06-09 14:51:25 in reply to 1 [link]

Please try again with any SQLite [check-in 56ff58c0b8905aa1 or later][1],
or using the latest prerelease-snapshot, and report back whether or not
this still an issue.

[1]: src:/timeline?c=56ff58c0b8905aa1