wrapper中有条件时候会自动拼接sql

而当wrapper中么有条件，直接走xml的动态sql会导致

sql语句没有其他条件却依然拼接了And 条件相当于：select....from... And 条件

解决方案：如果wrapper中没值时，手动加个where,避免后续的查询没有where 导致报错

<select id="selectNewPage" resultType="vo.RepairpartIoappAndUserPageVO">
        select * from( select a.*,b.nickname from cloud_repairpart_ioapp as a
        left join system_users as b on a.creator=b.id ) as result  ${ew.customSqlSegment}
        <if test="ew.customSqlSegment == null or ew.customSqlSegment == '' ">where 1 = 1</if>
        <if test="nickName != null and nickName != '' ">
            AND nickName Like  '%${nickName}%'
        </if>
        ORDER BY create_time;
</select>