quarkiverse / quarkus-mybatis

Quarkus MyBatis Extension
Apache License 2.0
88 stars 33 forks source link

MEMBER OF 语法分页时报错 #370

Open leanderli opened 9 months ago

leanderli commented 9 months ago

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" at line 8, column 21.

Was expecting one of:

"&"
")"
"::"
"<<"
">>"
"CONNECT"
"EMIT"
"EXCEPT"
"GROUP"
"HAVING"
"INTERSECT"
"MINUS"
"START"
"UNION"
"WINDOW"
"["
"^"
"|"