Bug #105782 Null byte breaks FTS double quotes

• Submitted: 2 Dec 2021 20:53
• Modified: 3 Dec 2021 6:42
• Reporter: Kieran Brahney
• Status: Verified
• Category: MySQL Server: FULLTEXT search
• Severity: S3 (Non-critical)
• Version: 8.0, 5.7
• OS: Any
• 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