解析MYBAITS XML SET+OTHERWISE 逗号问题

[Sharkzeng]

SQLe Version 1.2209.0

 <update id="updatePhoneRechargeStatus">
        update batch_recharge_record
        set
        <choose>
            <when test="isSuccess!=null and isSuccess!=''">
                success_amount = success_amount + #{amount},
                success_number=success_number +1,
                processing_amount = processing_amount - #{amount},
                processing_number=processing_number-1,
            </when>
            <otherwise>
                fail_amount = fail_amount + #{amount},
                fail_number=fail_number +1,
                processing_amount = processing_amount - #{amount},
                processing_number=processing_number-1,
            </otherwise>
        </choose>
        where record_no = #{recordNo} 
        and  processing_amount - #{amount} &gt;= 0
    </update>

听说 SET 会对 最后一个 更新字段的逗号 取消掉

warn语法错误或者解析器不支持，请人工确认SQL正确性	update dk_batch_recharge_record set success_amount = success_amount + ?, success_number=success_number +1, processing_amount = processing_amount - ?, processing_number=processing_number-1, fail_amount = fail_amount + ?, fail_number=fail_number +1, processing_amount = processing_amount - ?, processing_number=processing_number-1, where record_no = ? and processing_amount - ? >= 0 ;