not in (xxxx) 的bug

  <!--and s1.approve_type not in (#{notInApproveType}) 这种 and s1.approve_type not in ('0,4')只过滤0没过滤4 -->
            <if test="notInApproveType != null">
                and #{notInApproveType} not like concat('%',s1.approve_type,'%')
            </if>
原文地址:https://www.cnblogs.com/xuerong/p/9705194.html