From ae546078c5696ac73ad9f48c2c90163febb4a246 Mon Sep 17 00:00:00 2001 From: Eric Wong Date: Sat, 22 Aug 2020 06:06:25 +0000 Subject: searchidx: index THREADID in Xapian This is the `tid' column from over.sqlite3; and will be used for IMAP and JMAP search (among other things). --- lib/PublicInbox/Over.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'lib/PublicInbox/Over.pm') diff --git a/lib/PublicInbox/Over.pm b/lib/PublicInbox/Over.pm index a055b4cd..34d0b05d 100644 --- a/lib/PublicInbox/Over.pm +++ b/lib/PublicInbox/Over.pm @@ -213,7 +213,7 @@ sub get_art { my ($self, $num) = @_; # caching $sth ourselves is faster than prepare_cached my $sth = $self->{-get_art} //= $self->connect->prepare(<<''); -SELECT num,ds,ts,ddd FROM over WHERE num = ? LIMIT 1 +SELECT num,tid,ds,ts,ddd FROM over WHERE num = ? LIMIT 1 $sth->execute($num); my $smsg = $sth->fetchrow_hashref; -- cgit v1.2.3-24-ge0c7