此条件为由sql语句最后,userAgentRemovedProduct 值为"exclude" 但是却没有and (tulr.chan_prod_status is null or tulr.chan_prod_status = 0)这个条件,将如下语句往前提后居然出现了,好奇怪的错误
<if test="recommendNotsettlement != null and recommendNotsettlement == 'exclude'">
and (tulr.settle_enabled is null or tulr.settle_enabled = true)
</if>
<if test='userAgentRemovedProduct != null and userAgentRemovedProduct == "exclude"'>
and (tulr.chan_prod_status is null or tulr.chan_prod_status = 0)
</if>
```