解决方案:
正确使用
in
函数。一定要完整拷贝整个<if>...</if> 格式也一定要一样不然还是会报错
<select id="getFrontSeaList" resultType="com.xxx.common.vo.clue.ClueSeaListVo">
select
c.id,
c.oid,
c.name,
c.phone,
c.customer_type,
c.industry,
c.source,
c.create_time
from
clue c
where
1=1
and c.sales_uid = 0
<if test="oidList != null">
and c.oid in
<foreach collection="oidList" item="oidList" index="index" open="(" separator="," close=")">
#{oidList}
</foreach>
</if>
and c.is_delete = 0
</select>