整合springboot-mybatis后，批量插入入参不能带问号 ?

[GK0505]

Bug Description Caused by: java.sql.SQLException: TDengine Error: syntax error near 'http://127.0.0.1:801/pic?=d11i052e*dcei055-69490b-086f0b1ed' (invalid data or symbol)

To Reproduce Steps to reproduce the behavior:

1. 整合springboot-mybatis批量插入数据
2. 一张表有两个url，每个url都有问号，mapper： INSERT INTO ${tableName} USING face TAGS (#{tenantId,jdbcType=VARCHAR}) VALUES ( #{item.shotTime,jdbcType=TIMESTAMP}, #{item.faceId,jdbcType=VARCHAR}, #{item.leftTopX,jdbcType=INTEGER}, #{item.leftTopY,jdbcType=INTEGER}, #{item.rightBtmX,jdbcType=INTEGER}, #{item.rightBtmY,jdbcType=INTEGER}, #{item.traitImg,jdbcType=VARCHAR}, #{item.sceneImg,jdbcType=VARCHAR} )

   traitImg，sceneImg为url，带问号 3.出差源码 TSDBPreparedStatement 118行 this.sql = this.sql.replaceFirst("[?]", "NULL");

Expected Behavior

Screenshots If applicable, add screenshots to help explain your problem. mybatis mapper 初步判断出错的原因

Environment (please complete the following information):

• OS: [CentOS 7.5]
• Memory, CPU, current Disk Space
• TDengine Version [2.0.31]
• taos-jdbcdriver [2.0.4]
• mybatis-spring-boot-starter [2.1.1]

Additional Context Add any other context about the problem here.

[zyyang90]

请把问题写清楚一点，你这个是往tdengine里插入一个url，然后报错？你在Expected Behavior写的taos版本是2.0.3.1，在Environment写的TDengine版本是1.6.1.7

[liangyuanpeng]

可以尝试使用最新版本看是否还有这个问题

[zyyang90]

This issue is stale because it has been open for 30 days with no activity.