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

   ## Feature Request
   
   ### Is your feature request related to a problem?
   
   #11623
   
   ### Describe the feature you would like.
   
   Now, we have added validation logic for insert statements in the 
`ShardingInsertStatementValidator` class to ensure that the same record can 
only be routed to one shard. 
   
   But there are various scenarios that cause this exception to occur. The 
first is that the sharding key value in sql is not a literal, which leads to 
full routing. Just like `INSERT INTO t_order (order_id, user_id, status) VALUES 
(1+1, 2, 'insert');
   `. The second is that the sharding algorithm logic is abnormal, causing the 
same record to be routed to multiple shards. We need to distinguish these 
scenarios by different exception classes, so that users can quickly locate the 
problem.
   


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