mysql:IN最多只能查询1000个,如果要一次性查询出来,使用以下sql实现:
1、 <if test="(index % 999) == 998">
:余数等于998,将,置为NULL
SELECT
mph.PO_HEADER_ID,
mph.PO_NUMBER,
mid.INSTRUCTION_DOC_STATUS,
mid.INSTRUCTION_DOC_NUM
FROM
mt_po_header mph
LEFT JOIN mt_instruction mi ON mi.SOURCE_ORDER_ID = mph.PO_HEADER_ID
LEFT JOIN mt_instruction_doc mid ON mid.INSTRUCTION_DOC_ID = mi.SOURCE_DOC_ID
WHERE mph.TENANT_ID = 7
AND ( mph.PO_NUMBER IN
NULL ) OR mph.PO_NUMBER IN (#{item}
)