Skip to content
This repository was archived by the owner on Sep 12, 2018. It is now read-only.
This repository was archived by the owner on Sep 12, 2018. It is now read-only.

Don't use rowids as foreign key into fulltext values table #67

@ncalexan

Description

@ncalexan

Per http://www.sqlabs.com/blog/2010/12/sqlite-and-unique-rowid-something-you-really-need-to-know/ and others, VACUUM can re-assign rowids. At this time, we don't ever delete fulltext values, so this is a theoretical concern; but we should fix it, possibly by adding an INTEGER PRIMARY KEY AUTOINCREMENT to the fulltext values table.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions