Certain numerical substrings are ignored

gdpelican · 2016 年4 月 9 日 09:25

You’ll be interested in the post_search_data table, which stores tsvector information about each post (the tsvectors are weighted collections of lexemes / word roots, which postgres can compare to a search term much faster than a raw post body).

The class you’re looking for is lib/search.rb which is… well, a bit tangled, but the line which executes the search is here:

github.com/discourse/discourse

lib/search.rb

main


      
          advanced_filter(/\Astatus:noreplies\z/i) { |posts| posts.where("topics.posts_count = 1") }
          
          advanced_filter(/\Astatus:single_user\z/i) { |posts| posts.where("topics.participant_count = 1") }
          
          advanced_filter(/\Aposts_count:(\d+)\z/i) do |posts, match|
            posts.where("topics.posts_count = ?", match.to_i)
          end
          
          advanced_filter(/\Amin_post_count:(\d+)\z/i) do |posts, match|
            posts.where("topics.posts_count >= ?", match.to_i)
          end
          
          advanced_filter(/\Amin_posts:(\d+)\z/i) do |posts, match|
            posts.where("topics.posts_count >= ?", match.to_i)
          end
          
          advanced_filter(/\Amax_posts:(\d+)\z/i) do |posts, match|
            posts.where("topics.posts_count <= ?", match.to_i)
          end
          
          advanced_filter(/\Ain:first|^f\z/i) { |posts| posts.where("posts.post_number = 1") }

If I had a wild guess, I would guess that converting the word ‘chem123’ to a lexeme results in {'chem123':1}, which doesn’t match the tsquery 123

(The ‘f’ is for false, aka, the document ‘chem123’ isn’t a match for the search term ‘123’)

I definitely don’t have my head around a good fix for that, but I wish you luck! Maybe you could write a clause in there specifically for if the query is a number.

PS I found this post to be a really great intro to how postgres does its fulltext search.

话题		回复	浏览量
Search within topic is omitting results Bug	21	5298	2017 年6 月 2 日
Searches for single digits could prioritize occurrences of single-digits UX	0	636	2015 年10 月 21 日
Search for wb.camra.org.uk doesn't return any results Bug	16	1755	2017 年8 月 14 日
Are specific terms ignored from searches? Product Support	12	1558	2024 年10 月 14 日
Search only within topic titles Feature search	10	3343	2018 年2 月 20 日

Certain numerical substrings are ignored

相关话题