quarkus-mybatis
quarkus-mybatis copied to clipboard
MEMBER OF 语法分页时报错
WARN [com.bao.myb.ext.plu.inn.PaginationInnerInterceptor] (main) optimize this sql to a count sql has exception, sql:"select f.* from file_object f join ( select r.id from (
select id
from s_acl_2
where ? MEMBER OF(accessors_permits -> '$.browsers')
union all
select id
from s_acl_2
where ? MEMBER OF(accessors_permits -> '$.browsers')
union all
select id
from s_acl_2
where ? MEMBER OF(accessors_permits -> '$.browsers')
) r group by r.id
) s on s.id = f.acl_id", exception:
java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "MEMBER" <S_IDENTIFIER> at line 8, column 21.
Was expecting one of:
"&"
")"
"::"
"<<"
">>"
"CONNECT"
"EMIT"
"EXCEPT"
"GROUP"
"HAVING"
"INTERSECT"
"MINUS"
"START"
"UNION"
"WINDOW"
"["
"^"
"|"