Welcome, Guest! Log In | Create Account

Ticket #618 (new defect)

Opened 6 months ago

Last modified 6 months ago

Search doesn't handle really short words properly

Reported by: bharat Owned by:
Priority: major Milestone: 3.1
Version: 3.0 Beta 2 Keywords:
Cc:

Description

Steps to reproduce:
1) Create an item with the title "Per"
2) Search for "Per"

It doesn't show up because the FullText? match query:

SELECT g3_items.*, MATCH(g3_search_records.data) AGAINST ('Per') AS score FROM g3_items JOIN g3_search_records ON (g3_items.id = g3_search_records.item_id) WHERE MATCH(g3_search_records.data) AGAINST ('Per' IN BOOLEAN MODE) ORDER BY score DESC LIMIT 10 OFFSET 1;

doesn't do well with short words.

Change History

Changed 6 months ago by bharat

Perhaps if the keywords is less than 4 characters, don't use the fulltext index. This will result in weird results, perhaps.

Alternatively, let the user know that their search string was too short.

Changed 6 months ago by bharat

  • milestone changed from 3.0 Beta 3 to 3.1
Note: See TracTickets for help on using tickets.