TYPO3 Core

This is still a problem with TYPO3 9 and current git.

We have this issue with mysql fulltext search:

1. Search for "TYPO3-Schulung"
2. Lexer removes the "-", thus "TYPO3Schulung" is searched for
3. "index_fulltext.fulltextdata" is filled without the lexer, thus it contains "TYPO3-Schulung".
4. Nothing is found

The first solution would be to override the Lexer and drop "45" from lexerConf.removeChars. Now this happens:

1. Search for "TYPO3-Schulung"
2. Lexer does not remove the "-"
3. fulltext sql query is MATCH (index_fulltext.fulltextdata) AGAINST ('+typo3-schulung*' IN BOOLEAN MODE)
4. MySQL interprets this as +typo3 -schulung*, thus finding pages that contain "typo3" only, but not "schulung*".

I see two solutions:

1. Use the lexer for adjusting the fulltextdata during indexing, removing the hyphens (Bindestriche)
2. Quote search words when they contain a - minus

ROFL