Search: the count with a type filter fails and gives 0

closed
Max Rakhimov · 2026-10-03 · 28b438f6c987 · edited · issue

The count query of a search with a social type filter, for example type:post, builds a condition on si.type without a join of the social table, so SQLite fails with: no such column: si.type. The error is ignored, the total reads 0, and with a limit the total and has_more are wrong. The list query of the same search is correct. Found in the review of the reference target change; not a regression of it.

edits
#commit:28b438f6c987@gitmsg/pm
labels
kind/bug, priority/normal, area/search