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 Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: FULLTEXT search Severity:S4 (Feature request)
Version:5.6.13 OS:Any
Assigned to: CPU Architecture:Any

[1 Jul 2013 4:04] Shaohua Wang
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 '*'.