当前使用版本(必填,否则不予处理)

com.baomidou mybatis-plus-boot-starter 3.4.3.4

该问题是如何引起的？(确定最新版也有问题再提!!!)

1、设置排序参数page.setOrders(Lists.newArrayList(new OrderItem("gmvTotal", false)));

    // 分页和数据

2、IPage queryaaa(PageDTO page);

3、对应SQL如下：

select
        sum (gmv) as gmvTotal,
aid
        from gmv
        where
multiSearchAnyCaseInsensitiveUTF8(gmv_name,['面包','牛奶'])
group by aid

使用了clickhouse的multiSearchAnyCaseInsensitiveUTF8函数

重现步骤(如果有就写完整)

报错信息

        group by aid", exception:
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("
    at line 51, column 57.

Was expecting one of:

    "&"
    ")"
    "::"
    "<<"
    ">>"
    "COLLATE"
    "["
    "^"
    "|"

Comment From: miemieYaho

jsqlparser 不支持它

Comment From: dislazy

是需要我手动写order by 对吧