I tried to execute this sql but Exception happened.
source code is here
@Select(
"""
SELECT
COUNT(*)
FROM
order
WHERE
order_id IN
<foreach item="id" collection="orderIds" open="(" separator="," close=")" >
#{id}
</foreach>
"""
)
fun findByOrderIds(@Param(value = "orderIds") orderIds: List<String>): Int
Error message is here↓
nested exception is org.apache.ibatis.binding.BindingException: Parameter 'id' not found. Available parameters are [orderIds, param1]
I cannot find wrong point. If you have idea please let me know.