loopback-connector-mysql
loopback-connector-mysql copied to clipboard
loopbackio
n-gram specification on FULLTEXT index
Suggestion
We can use MATCH operation with Natural Language mode.
However, we cannot specify parser for a FULLTEXT index.
Because type property should get USING prefix, but FULLTEXT index are never get a USING.
We want to just ADD FULLTEXT INDEX indexName (pName) WITH PARER ngram, not ADD FULLTEXT INDEX indexName (pName) USING WITH PARER ngram.
Please avoid USING prefix on FULLTEXT index for type property.
Acceptance criteria
TBD - will be filled by the team.
It maybe has only WITH PARSER xxx after column specify, right?
Then, we can add WITH PARSER on FULLTEXT index that is like on USING .