sql 使用 in 后数据量太大报错

select id="getPageInfo" parameterClass="map" resultClass="java.util.HashMap"> select b.aab001, c.aab069, a.aac001, a.aac003, a.aac147, a.aac998, a.aac007, b.aac049, b.aae206, b.aae140, a.aic162, a.aac060 from ac01 a, ac02 b, ae10 c where a.aac001 = b.aac001(+) and b.aab001 = c.aaz001(+) <isNotEmpty prepend="AND" property="aac001"> <!-- aac001 --> (A.AAC001 = #aac001# OR A.AAC998 = #aac001# OR A.AAC147 = #aac001#) </isNotEmpty> <isNotEmpty prepend="AND" property="aac001s"> <!-- aac001 --> (A.AAC001 <iterate property="aac001s" prepend="IN" open="(" conjunction="," close=")"> #aac001s[]# </iterate> OR A.AAC998 <iterate property="aac001s" prepend="IN" open="(" conjunction="," close=")"> #aac001s[]# </iterate> OR A.AAC147 <iterate property="aac001s" prepend="IN" open="(" conjunction="," close=")"> #aac001s[]# </iterate> ) </isNotEmpty> </select>

 

sql 使用 in 后数据量太大报错

标签：util   iter   inf   page   配置   iba   src   col   http