☰

语法错误，意外的 $end，预期为 FTS_TEXT 或 FTS_TERM 或 FTS_NUMB 或 '('

tag-icon • tag-icon mysql percona
语法错误，意外的 $end，预期为 FTS_TEXT 或 FTS_TERM 或 FTS_NUMB 或 '('

/var/log/mysqld.log 中有很多如下消息这是什么意思？

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%$
    syntax error, unexpected $end, expecting FTS_TEXT or FTS_TERM or FTS_NUMB or '('
    syntax error, unexpected $end, expecting FTS_TEXT or FTS_TERM or FTS_NUMB or '('
    syntax error, unexpected $end, expecting FTS_TEXT or FTS_TERM or FTS_NUMB or '('
    syntax error, unexpected $end, expecting FTS_TEXT or FTS_TERM or FTS_NUMB or '('
    %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%$

centos 6.4 服务器版本：5.6.12-56 Percona Server（GPL），版本 rc60.4，修订版 393

答案1

你可能在涉及以下查询的语法错误：全文搜索。

答案2

如果您使用的是 innoDB，则要匹配/反对的 FT 查询可能包含此特殊字符：*。请参阅此错误报告：https://bugs.mysql.com/bug.php?id=78485

相关内容