MyBatis sql not return result when give 0 value
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..** java […]