MyBatis-Plus TDengine分页查询时，报错Encountered unexpected token: "interval

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

v3.5.3

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

c.b.m.e.p.i.PaginationInnerInterceptor : optimize this sql to a count sql has exception, sql:"SELECT _wstart as ts ,avg(water_level) as water_level ,avg(water_level_elevation) as water_level_elevation,avg(battery) as battery from db_cellar_platform.t_cellar_history_data WHERE 1=1

        and ts  >=   ?


        and ts <=   ?


        and device_id in
         (  
        ?
     )

     interval(1d) fill(prev)", exception:

net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "interval" "INTERVAL" at line 17, column 4.

Was expecting one of:

";"
"CONNECT"
"EMIT"
"GROUP"
"HAVING"
"START"
<EOF>

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

报错信息

c.b.m.e.p.i.PaginationInnerInterceptor : optimize this sql to a count sql has exception, sql:"SELECT _wstart as ts ,avg(water_level) as water_level ,avg(water_level_elevation) as water_level_elevation,avg(battery) as battery from db_cellar_platform.t_cellar_history_data WHERE 1=1

        and ts  >=   ?


        and ts <=   ?


        and device_id in
         (  
        ?
     )

     interval(1d) fill(prev)", exception:

net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "interval" "INTERVAL" at line 17, column 4.

Was expecting one of:

";"
"CONNECT"
"EMIT"
"GROUP"
"HAVING"
"START"
<EOF>

Comment From: springbootyp

我也出现如上错误，请问解决了吗？ Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "?" "?" at line 2, column 36.

Was expecting one of:

";"
"ACTION"
"ACTIVE"
"ALGORITHM"
"ARCHIVE"
"ARRAY"
"AS"

Comment From: qmdx

https://baomidou.com/plugins/pagination/#page-%E7%B1%BB 分页 optimizeCountSql 属性设置 false 关闭 sql 优化试试