mybatis-plus在mapper.xml中用Group By 出现的问题

比眉伴天荒 2023-01-03 06:20 106阅读 0赞

我的错误是  
Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error of sql ： 这些是sql语句

首先 sql语句在数据库里直接运行是没有问题的，而且在我的本地运行项目也没有报这种错误，到了服务器上就会报错，我本地和服务器环境一致，这种问题也是出现多次了

经历了三个小时的反复测试终于成功

我修改后的mapper文件

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/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>
    
        <select id="findPage" resultMap="ResultMap">
            select min(name) as tname,id_card,min(relation) as trelation ,recognizee_name,min(recognizee_card) as recognizeeCard,SUM(coverage) as coverages
            from bbc_zsbank where id_card = #{params.idCard}
            GROUP BY recognizee_name,id_card
        </select>
    
    </mapper>

修改前文件代码

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/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"/>
            <result column="relation" property="relation"/>
            <result column="recognizee_name" property="recognizeeName"/>
            <result column="recognizee_card" property="recognizeeCard"/>
            <result column="coverages" property="coverages"/>
        </resultMap>
    
    
        <select id="findPage" resultMap="ResultMap">
            select 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
        </select>
    
    
    </mapper>

给不是 group by 条件的字段加了 min函数 起了别名让这个字段脱离数据库属性