Bug #105782 Null byte breaks FTS double quotes
Submitted: 2 Dec 2021 20:53 Modified: 3 Dec 2021 6:42
Reporter: Kieran Brahney Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: FULLTEXT search Severity:S3 (Non-critical)
Version:8.0, 5.7 OS:Any
Assigned to: CPU Architecture:Any

[2 Dec 2021 20:53] Kieran Brahney
Description:
The presence of the null byte in the match statement results in a syntax error. Without the null byte there is no syntax error.

My understanding from the docs is that everything enclosed within the double quotes will be searched for exactly. That means FTS special characters do not need to be escaped.

How to repeat:
https://www.db-fiddle.com/f/rtk6FqkTJgyUryHT2huxbQ/1
[3 Dec 2021 6:42] MySQL Verification Team
Hello Kieran,

Thank you for the report and test case.

regards,
Umesh