Bug #69626 InnoDB fulltext should return syntax error in boolean mode for leading '*'

• Submitted: 1 Jul 2013 4:04
• Modified: 6 Jul 2013 6:58
• Reporter: Shaohua Wang
• Status: Verified
• Category: MySQL Server: FULLTEXT search
• Severity: S4 (Feature request)
• Version: 5.6.13
• OS: Any
• CPU Architecture: Any

[1 Jul 2013 4:04] Shaohua Wang

Description:
In order to keep backword compatibility with MyISAM, we ignores leading '*' in InnoDB.(original bug: http://bugs.mysql.com/bug.php?id=68948).

But we plan to deprecate it in 5.8 or later for we still think 'syntax error' is the right behavior.

If you think this affect you, please click the "Affects Me" button. Any comments are welcomed.

How to repeat:
match(content) against('*complicate*' in boolean mode);

returns result just like

match(content) against('complicate*' in boolean mode);

the leading '*' is ignored.

Suggested fix:
Return 'syntax error' when there is a leading '*'.