nevereverever opened a new issue #4844: Batch insert cannot exceed 65535 columns
URL: https://github.com/apache/incubator-shardingsphere/issues/4844
 
 
   version : sharding-proxy 4.0.1
   
   description:
   I have a table of 44 columns,I use jdbc batch insert with 
preparedstatement,like insert into table (xxx,xxx,...xxx) 
values(?,?...,?),(?,?...,?),(?,?...,?),(?,?...,?)...,(?,?...,?).
   when `?` more than 65535,report this exception:
   ```bash
   java.sql.SQLException: Parameter index out of bounds.
   ```
   
   I tested many more tables and found that column 65535 was a critical value.
   
   MySQL does not have this limitation.
   
   I want to know if this is intentional restriction or is it a bug?

----------------------------------------------------------------
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]


With regards,
Apache Git Services

Reply via email to