[Bug] Mysql-JDBC can not adapter match_all pr match_all fuction

[chenchurong]

Search before asking

• I had searched in the issues and found no similar issues.

Version

2.0-beta (Latest)

What's Wrong?

can not executeQuery by jdbc statement when i use [inverted index]

i guess mysql driver can not Adapter fuction match_all or match_any

What You Expected?

get result by query sql

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[chenchurong]

` org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [select count(*) from ( select entity_code, credit_code, company_name_source from dim_kp_company_main where company_name_source match_all '万科' ) a]; SQL state [HY000]; error code [1105]; errCode = 2, detailMessage = Syntax error in line 1:
...where company_name_source match_all '万科' ) a
^
Encountered: IDENTIFIER
Expected: ||, COMMA
; nested exception is java.sql.SQLException: errCode = 2, detailMessage = Syntax error in line 1:
...where company_name_source match_all '万科' ) a
^
Encountered: IDENTIFIER
Expected: ||, COMMA

at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1542)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:393)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:465)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:475)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:508)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:515)
at com.lighthouse.chaos.util.DorisQueryService.getTotalCount(DorisQueryService.java:128)
at com.lighthouse.chaos.util.DorisQueryService.selectForPagination(DorisQueryService.java:49)
at com.lighthouse.chaos.util.DorisQueryService$$FastClassBySpringCGLIB$$ae975b77.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
at 

`

[echo-hhj]

在2.0beta中使用倒排索引建表，并成功使用索引查询，您可以再尝试一下，或者把建表语句和查询语句给我，我帮您验证一下

[echo-hhj]