What does HRESULT 0x87AF0A13 (SQLITE_E_CONSTRAINT_ROWID) mean?

Status / error code:

Category:

Constant name:

Source:

Facility:

Operating System:

Description:

SQLITE_E_CONSTRAINT_ROWID means SQLite could not assign a unique rowid to a row.

Previous	Next
SQLITE_E_IOERR_DELETE	SQLITE_E_IOERR_BLOCKED

SQLITE_E_CONSTRAINT_ROWID

SQLITE_E_CONSTRAINT_ROWID corresponds to SQLITE_CONSTRAINT_ROWID. The operation attempted to create a row whose rowid is not unique.

Check whether the application explicitly supplies rowid, _rowid_, oid, or an INTEGER PRIMARY KEY alias.
Review import or restore code that may reuse row identifiers from another database.
Do not assume this is the same as a generic UNIQUE violation; rowid behavior is specific to rowid tables.

SELECT rowid, * FROM your_table WHERE rowid = ?;