mybatis in超过1000报错解决方案

<delete id="deleteByMsgIds">
		DELETE FROM message
		WHERE msg_id in
        <trim suffixOverrides=" OR id IN ()">
            <foreach item="item" index="index" collection="list"
                     open="(" close=")">
                <if test="index != 0">
                    <choose>
                        <when test="index % 1000 == 999">) OR id IN (</when>
                        <otherwise>,</otherwise>
                    </choose>
                </if>
                #{item}
            </foreach>
        </trim>
	</delete>