shardingSphere jdbc 5.3.1 postgresql分页查询报错

使用环境:

shardingSphere jdbc 5.3.1
postgresql 12.9
spring-boot 2.7.6
mybatis 3.5.11

场景、问题:

sql进行分页运行进行报错:
image


异常信息:
org.apache.ibatis.executor.ExecutorException: Error preparing statement. Cause: java.lang.ClassCastException: class org.apache.shardingsphere.sql.parser.sql.common.segment.dml.expr.BinaryOperationExpression cannot be cast to class org.apache.shardingsphere.sql.parser.sql.common.segment.dml.expr.simple.LiteralExpressionSegment (org.apache.shardingsphere.sql.parser.sql.common.segment.dml.expr.BinaryOperationExpression and org.apache.shardingsphere.sql.parser.sql.common.segment.dml.expr.simple.LiteralExpressionSegment are in unnamed module of loader ‘app’)

sql改为:
SELECT id FROM t_address LIMIT 10 OFFSET 0
正常运行

京ICP备2021015875号