mybatis处理in条件超过1000个字符的办法

一、此方法当in中的字符超过1000就会报错
1.mapper.java
List<String> queryClueGrpOrgNamesPlus(@Param("ids")List<String> ids);
2.mapper.xml
<select id="queryClueGrpOrgNamesPlus" resultType="java.lang.String">
    select t.short_c_name from auap_t_org t
    <foreach collection="ids" item="itemId" separator="," open=" where t.org_no in (" close=")">
        #{itemId}
    </foreach>
</select> 

二、改造后的方法
<select id="queryClueGrpOrgNamesPlus" resultType="java.lang.String">
    select t.short_c_name from auap_t_org t
    inner join
    <foreach collection="ids" item="itemId" separator=" union all " open="(" close=") t1">
        select #{itemId} as orgNo form dual
    </foreach>
    on t.org_no = t1.orgNo
</select>