Hi, wknauf---, On Sep 12, wknauf--- via discuss wrote:
Question 1: this was changed by https://jira.mariadb.org/browse/MDEV-20797
It was https://github.com/MariaDB/server/commit/f076dc2f667d9270ca08421d466dcbc3527... and the commit message is - InnoDB should ignore the single word followed by apostrophe while tokenising the document. Example is that if the input string is O'brien then right now, InnoDB seperates into two tokens as O, brien. But after this patch, InnoDB can ignore the token 'O' and consider only 'brien'. Does it help?
Question 2: still open. I asked the same here: https://stackoverflow.com/questions/78969640/mariadb-fulltext-index-tokeniza...
I'll let InnoDB developer answer that Regards, Sergei Chief Architect, MariaDB Server and security@mariadb.org