当前使用版本(必填,否则不予处理)
3.4.2
该问题是如何引起的?(确定最新版也有问题再提!!!)
使用自定义SQL中MATCH查询关键字
重现步骤(如果有就写完整)
使用MATCH关键字报出警告
报错信息
optimize this sql to a count sql has exception, sql:"SELECT
id,
uid,
title,
label,
view_num,
create_time,
update_time,
image_uri
FROM
user_hr_articles
WHERE MATCH ( title, label ) AGAINST (? IN NATURAL LANGUAGE MODE)
ORDER BY
create_time DESC", exception:
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "MATCH" "MATCH"
at line 12, column 15.
Was expecting one of:
"!"
"("
"NOT"