mybatis-plus在l中⽤GroupBy出现的问题
我的错误是
Cau: ptions.MybatisPlusException: Error: Method queryTotal execution error of sql ： 这些是sql语句
⾸先 sql语句在数据库⾥直接运⾏是没有问题的，⽽且在我的本地运⾏项⽬也没有报这种错误，到了服务器上就会报错，我本地和服务器环境⼀致，这种问题也是出现多次了
广州夜大经历了三个⼩时的反复测试终于成功
我修改后的mapper⽂件need
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-////DTD Mapper 3.0//EN" "/dtd/mybatis-3-mapper.dtd">
英语口语交际
<mapper namespace="com.bjbss.bbcsupport.mapper.BbcZsbankMapper">
英文翻译在线转换器
<resultMap id="ResultMap" type="com.bjbss.bbcsupport.domain.BbcZsbank">
<result column="batch_number" property="batchNumber"/>
<result column="tname" property="name"/>
日文翻译中文转换器
<result column="id_card" property="idCard"/>
<result column="trelation" property="relation"/>
<result column="recognizee_name" property="recognizeeName"/>
<result column="recognizeeCard" property="recognizeeCard"/>
会计电算化是什么<result column="coverages" property="coverages"/>
</resultMap>
<lect id="findPage" resultMap="ResultMap">
lect min(name) as tname,id_card,min(relation) as trelation ,recognizee_name,min(recognizee_card) as recognizeeCard,SUM(coverage) as covera ges
from bbc_zsbank where id_card = #{params.idCard}
GROUP BY recognizee_name,id_card
</lect>
</mapper>
修改前⽂件代码
<?xml version="1.0" encoding="UTF-8"?>
maine
<!DOCTYPE mapper PUBLIC "-////DTD Mapper 3.0//EN" "/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.bjbss.bbcsupport.mapper.BbcZsbankMapper">
<resultMap id="ResultMap" type="com.bjbss.bbcsupport.domain.BbcZsbank">
<result column="batch_number" property="batchNumber"/>
<result column="name" property="name"/>
<result column="id_card" property="idCard"/>
weld<result column="relation" property="relation"/>
<result column="recognizee_name" property="recognizeeName"/>
rome
<result column="recognizee_card" property="recognizeeCard"/>
<result column="coverages" property="coverages"/>
</resultMap>
<lect id="findPage" resultMap="ResultMap">
lect name,id_card,relation ,recognizee_name,recognizee_card,SUM(coverage) as coverages
from bbc_zsbank where id_card = #{params.idCard}
GROUP BY recognizee_name,id_card
</lect>tyrande
</mapper>
给不是 group by 条件的字段加了 min函数 起了别名让这个字段脱离数据库属性
