[GitHub] [shardingsphere] TeslaCN commented on issue #18961: 5.1.2-ShardingProxy java.lang.Integer cannot be cast to java.lang.Long

[GitBox <gi...@apache.org>]

TeslaCN commented on issue #18961:
URL: https://github.com/apache/shardingsphere/issues/18961#issuecomment-1179908464

   Hi @chenliang7558 
   
   I found that the type depends on the value:
   
   ```sql
   INSERT INTO `t_order` ( `order_id`, `user_id`, `status`) VALUES ( 100000 ,100000, 'test'); 
   ```
   <img width="1424" alt="image" src="https://user-images.githubusercontent.com/20503072/178179100-373481fe-ee41-4b38-80fb-cce33907a8ef.png">
   
   ```sql
   INSERT INTO `t_order` ( `order_id`, `user_id`, `status`) VALUES ( 2147483648 ,100000, 'test'); 
   ```
   <img width="1396" alt="image" src="https://user-images.githubusercontent.com/20503072/178179250-9ae113ff-7e09-455c-bd0c-157aef599167.png">
   
   Column's type is not available for SQL parser, so you may use `Number` or check the type on your own.
   You may refer to our `ModShardingAlgorithm`.
   


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org