Historical context on why Boolean mode was out of scope for the initial implementation: The MySQL documentation does not clearly explain when to use different full-text search modes. The team chose the default ("out-of-the-box") full-text search implementation for simplicity. Boolean mode was not used due to several drawbacks: It does not automatically sort results by relevance, requiring extra work to compute and apply relevance scores manually. Using Boolean mode would require extending the query parser to support its custom syntax. Implementing these changes would have added significant complexity without a clear path to automation.
The default mode already handles relevance sorting automatically, which met user needs with less effort.
|