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

   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   5.5.2
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-JDBC
   ### Expected behavior
   When my sharding key is alphabetical, I expect to successfully configure the 
binding tables `t_order` and `t_order_item`.
   ### Actual behavior
   An exception occurs when configuring the binding tables:
   **Caused by: 
org.apache.shardingsphere.sharding.exception.metadata.InvalidBindingTablesException:
 Invalid binding table configuration.**
   ### Reason analyze (If you can)
   The `DATA_NODE_SUFFIX_PATTERN` uses `\\d+$`, which causes the system to 
expect the suffix of the binding tables to be numeric. However, the actual 
table names `t_order_a` and `t_order_item_a` have alphabetical suffixes, 
leading to the configuration being rejected.
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule 
configuration, when exception occur etc.
   
   1. Create tables `t_order` and `t_order_item`, with their sharding tables 
named `t_order_a` and `t_order_item_a`.
   2. Configure the binding tables as follows:
   
   > bindingTables:
   >   - t_order,t_order_item
   
   3. Start the application and observe the exception.
   ### Example codes for reproduce this issue (such as a github link).
   


-- 
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-unsubscr...@shardingsphere.apache.org.apache.org

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

Reply via email to