Open
Description
I wanna batch updating the records with dynamic columns
Here is the example:
UPDATE xxx
SET
${field} = CASE id
WHEN #{item.id} THEN #{item[${field}]}
END
WHERE xxx.id IN
#{item.id}
I definitely declare correct params of the function in mapper with the @param annotation.
The inner loop with foreach tag can't be iterated.
The exception like follow:
nested exception is org.apache.ibatis.binding.BindingException: Parameter 'item' not found. Available parameters are [updateColumnList, itemList, param1, param2]