You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/07/10 03:18:28 UTC

[GitHub] [shardingsphere] zhf122728281 edited a comment on issue #6311: batch insert have a bug

zhf122728281 edited a comment on issue #6311:
URL: https://github.com/apache/shardingsphere/issues/6311#issuecomment-656457116


   > > Hi @zhf122728281
   > > Could you set `sql.show` as `true`? Let us look at what SQL passed into ShardingSphere and rewritten SQL is.
   > > BTW, my impression about `batch insert` is like `preparedStatemnt.addBatch()`. Is it your thinking as well?
   > > Trista
   > 
   > 11:00:55.858 DEBUG [http-nio-9911-exec-182,8a3c4e3850fdea1c,bae549b8988841da,true,10.10.92.101] c.c.d.k.m.d.TbMapper.batchInsert[BaseJdbcLogger.java:159] -> ==> Preparing: insert into tb ( v ) values ( ? ) ; insert into tb ( v ) values ( ? )
   > 11:00:55.860 DEBUG [http-nio-9911-exec-182,8a3c4e3850fdea1c,bae549b8988841da,true,10.10.92.101] c.c.d.k.m.d.TbMapper.batchInsert[BaseJdbcLogger.java:159] -> ==> Parameters: fds(String), fafs32(String)
   
   ‘sql.show as true’ is invalid
   
   ![image](https://user-images.githubusercontent.com/20379651/87112655-fb99bf80-c29e-11ea-8485-bed840a2e800.png)
   
   


----------------------------------------------------------------
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:
users@infra.apache.org