Search is broken

[simonw]

https://datasette.io/-/beta?q=css

[simonw]

Downgrading to 0.64 did not fix it:

The index at https://datasette.io/dogsheep-index has stuff in though.

[simonw]

Huh... these both returned 0 results:

• https://datasette.io/dogsheep-index/search_index?_search=css
• https://datasette.io/dogsheep-index/search_index?_search=python

Even though https://datasette.io/dogsheep-index/search_index lists 2,646 rows and a like search https://datasette.io/dogsheep-index/search_index?title__contains=css returns results.

[simonw]

select count(rowid) from search_index where rowid in (select rowid from search_index_fts)

Returns 2646 so it's not a mismatch in rowid values.

[simonw]

I downloaded the DB and replicated the bug locally, then ran this:

sqlite-utils rebuild-fts dogsheep-index.db

And it seemed to fix it!

[simonw]

Here's what that does: https://github.com/simonw/sqlite-utils/blob/5d123f031fc4fadc98f508e0ef6b7b6671e86155/sqlite_utils/cli.py#L331-L337C34

Which runs INTO [{table}]([{table}]) VALUES('rebuild');.

[simonw]

If this fixes it I should update dogsheep-beta index to run a rebuild after it does the indexing.

[simonw]

That fixed it.