原本写法
<if test="filter.bugId != null and filter.bugId != ''">
AND
<choose>
<when test="filter.bugId == '0'">
(a_s.bug_id is null or a_s.bug_id = '' or a_s.bug_id = '0')
</when>
<otherwise>
a_s.bug_id like concat('%', #{filter.bugId}, '%')
</otherwise>
</choose>
</if>
test="filter.bugId == '0'一直为false,匹配不上0
换了写法
<if test="filter.bugId != null and filter.bugId != ''">
AND
<choose>
<when test="filter.bugId == 0">
(a_s.bug_id is null or a_s.bug_id = '' or a_s.bug_id = '0')
</when>
<otherwise>
a_s.