quarkus-mybatis icon indicating copy to clipboard operation
quarkus-mybatis copied to clipboard

MEMBER OF 语法分页时报错

Open leanderli opened this issue 1 year ago • 0 comments

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"
"["
"^"
"|"

leanderli avatar Nov 09 '23 06:11 leanderli