postgresql对变量类型比较敏感,对相应的变量进行类型转换之后就可以了
修改前:
<if test="lx !=null and lx.size>0 ">
AND t.lx in
<foreach collection="lx" item="lxItem" separator="," open="(" close=")">
#{lxItem}
</foreach>
</if>
修改后:
<if test="lx !=null and lx.size>0 ">
AND t.lx in
<foreach collection="lx" item="lxItem" separator="," open="(" close=")">
CAST(#{lxItem} AS SMALLINT)
</foreach>
</if>