[GitHub] [shardingsphere] tuichenchuxin commented on issue #13670: Execute insert sql, and the sql primary key is negative, the error is: "outside valid range for the datatype BIGINT"

GitBox Sun, 21 Nov 2021 17:39:10 -0800


tuichenchuxin commented on issue #13670:
URL: 
https://github.com/apache/shardingsphere/issues/13670#issuecomment-974996655



   > I found the reason: MySQL has enabled the primary key auto-increment 
situation, and the inserted ID is a negative number, it will cause this problem。
   > 
   > When using primary key auto-increment, the 
ProxyJDBCExecutorCallback.getGeneratedKeyIfInteger(final Statement statement) 
method will call resultSet.getLong, which causes this problem；
   > 
   > 
![image](https://user-images.githubusercontent.com/41990755/142555740-02be8e0a-2784-4f82-98a5-beb508ae87f2.png)
   
   Is a config problem or 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.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

[GitHub] [shardingsphere] tuichenchuxin commented on issue #13670: Execute insert sql, and the sql primary key is negative, the error is: "outside valid range for the datatype BIGINT"

Reply via email to