Skip to content

FOLLOW-UP: Populate FTS5 index with existing data on --searchable migration (from PR #284) #287

@adnaan

Description

@adnaan

Context

The generated FTS5 migration creates the virtual table and triggers but doesn't populate it with existing rows. If --searchable is added to a resource that already has data, search results will be empty until records are updated.

Fix: Add INSERT INTO table_fts(...) SELECT ... FROM table after CREATE VIRTUAL TABLE in the migration template.


This issue was automatically created by prmonitor from PR review comments.

Metadata

Metadata

Assignees

No one assigned

    Labels

    follow-upFollow-up task from PR reviewfrom-reviewIssue originated from PR review

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions