dolthub / dolthub/dolt

Support `IN BOOLEAN MODE` full-text search syntax (for Mediawiki)

Open
#7,619 0 comments 0 reactions 1 assignee Claimed by @zachmu View on GitHub
correctness enhancement integrations sql
Dominant language
Go
Stars
24.4k
Forks
873
Avg merge
1d 5h
Merged PRs (30d)
108

Description

Mediawiki uses [MySQL's `IN BOOLEAN MODE` for boolean full-text searches](https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html), but because Dolt doesn't support that, Mediawiki's search functionality doesn't work when running on Dolt.

Here's the error from Dolt's logs:
```
WARN[0236] error running query connectTime="2024-03-14 17:37:02.512541 -0700 PDT m=+236.209809418" connectionDb=media_wiki connectionID=67 error="\"IN BOOLEAN MODE\" is not supported yet" query="SELECT /* SearchMySQL::searchInternal */ page_id,page_namespace,page_title FROM `page` JOIN `searchindex` ON ((page_id=si_page)) WHERE ( MATCH(si_title) AGAINST('+canada ' IN BOOLEAN MODE) ) AND page_namespace = 0 ORDER BY MATCH(si_title) AGAINST('+canada ' IN NATURAL LANGUAGE MODE) DESC LIMIT 21 "
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.