AlistGo / AlistGo/alist

use ngram parser for full-text index

Abierto
#4,998 4 comentarios 1 reacción 0 asignados Ver en GitHub
accepted enhancement
Lenguaje dominante
Go
Estrellas
50.2k
Forks
7.9k
Merge medio
7 d 21 h
PR fusionados (30 d)
6

Descripción

### Please make sure of the following things

- [X] I have read the [documentation](https://alist.nn.ci).
- [X] I'm sure there are no duplicate issues or discussions.
- [X] I'm sure this feature is not implemented.
- [X] I'm sure it's a reasonable and popular requirement.

### Description of the feature / 需求描述

Use the `ngram` parser for full-text indexing in versions 5.7 and newer

### Suggested solution / 实现思路

```sql
CREATE FULLTEXT INDEX idx_search_nodes_name ON search_nodes(name) WITH PARSER ngram;
```

### Additional context / 附件

- https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-ngram.html
- https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-ngram.html
- https://dev.mysql.com/doc/refman/8.1/en/fulltext-search-ngram.html

Guía de contribución

Abrir la guía de contribución

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.