MyBatis-Plus 分页插件left join的count查询语句错误

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

3.4.2

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

@InterceptorIgnore(tenantLine = "true")
List<Map<String, String>> selectMapsPage(@Param("page") Page<Map<String, String>> page);

自定义mapper sql

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

参考： https://www.cnblogs.com/hongzm/p/8145149.html

报错信息

预期输出：

SELECT COUNT(*) from tbl_name a left join mysql.help_topic b 
on b.help_topic_id < (LENGTH(a.userName)-LENGTH(REPLACE(a.userName,',',''))+1)

实际输出：

SELECT COUNT(*) from tbl_name a;

Comment From: wyy0117

left join 分页查询时，count有问题 list查询： select xxxxx from libra_question question LEFT JOIN libra_question_options questionOptions ON question.id = questionOptions.question_id where question.answer_id=? LIMIT ? count实际输出输出： SELECT COUNT(*) FROM libra_question question WHERE question.answer_id = ? count预期输出： select count(*) from libra_question question LEFT JOIN libra_question_options questionOptions ON question.id = questionOptions.question_id where question.answer_id=?