DishJi opened a new issue #8361:
URL: https://github.com/apache/shardingsphere/issues/8361
**Version**
Springboot2.2.9 | mybatis-plus| sharding-jdbc-spring-boot-starter 4.1.1
**Mybatis.xml**
```
<update id="updateForListApi" parameterType="java.util.Map">
UPDATE user_record
<trim prefix="set" suffixOverrides=",">
<trim prefix="synchroPoint =case" suffix="end,">
<foreach collection="list" item="item" index="index">
<if test="item.synchroPoint!=null">
when (id=#{item.id}) then #{item.synchroPoint}
</if>
</foreach>
</trim>
</trim>
WHERE
user_id=#{userId}
and id IN
<foreach collection="list" item="item" index="index" separator=","
open="(" close=")">
#{item.id}
</foreach>
</update>
```
**Parameter Value**
**preciseShardingValue**
The value of userId cannot be obtained correctly, but when I fix the value
of userId in mybatis.xml, preciseShardingValue can be obtained correctly.
For example
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
