[GitHub] [shardingsphere] ThisOnly opened a new issue, #13670: Execute insert sql, and the sql primary key is negative, the error is: "outside valid range for the datatype BIGINT"

Sun, 09 Oct 2022 23:42:56 -0700 


ThisOnly opened a new issue, #13670:
URL: https://github.com/apache/shardingsphere/issues/13670

   ###  version of ShardingSphere: 5.0.0
   
   ###  ShardingSphere-Proxy
   
   ### Expected behavior
   execution succeed
   
   ### Actual behavior
   '18446744073709548257' in column '1' is outside valid range for the datatype 
BIGINT.
   
   ### Reason analyze:
   The primary key type is: bigint
   When the sql insert primary key is positive, the execution is correct, if it 
is negative, the execution is wrong, but no matter whether it is positive or 
negative, the data has actually entered the database
   
    ###SQL to execute:
   INSERT INTO db0.tb0 ( id, start_active_date, enable_flag, type_code, 
segment_value )
   VALUES(-33454,'2021-05-26','Y','DEPT','TEST1001')
   
![image](https://user-images.githubusercontent.com/41990755/142230662-6686467f-7632-429d-92e7-857c003607b7.png)
   
![image](https://user-images.githubusercontent.com/41990755/142230059-107a66c9-d084-4a1d-9479-d4f15cf0e8a6.png)
   
![image](https://user-images.githubusercontent.com/41990755/142230152-296829aa-eaa4-436f-9945-13ecdc3ee328.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.

To unsubscribe, e-mail: 
[email protected]

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

Reply via email to