<code> select * from table where
<if test="amount!= null">
amount >= #{amount, jdbcType=VARCHAR}
</if>
</code>
<code> select * from table where
<if test="amount!= null">
amount >= #{amount, jdbcType=VARCHAR}
</if>
</code>
select * from table where
<if test="amount!= null">
amount >= #{amount, jdbcType=VARCHAR}
</if>
When give from swagger “amount”: 0, not return result. But greater than 0 return result. How handle this. amount column is numeric(20, 2) default 0 not null In reguestDto this format BigDecimal. How change in mybatis retun >0 full rows. Thanks..**
4