[GitHub] [shardingsphere] devin-wanghuixiong commented on issue #28249: 多表绑定BUG,版本5.4/5.3.2

Thu, 24 Aug 2023 09:26:13 -0700 


devin-wanghuixiong commented on issue #28249:
URL: 
https://github.com/apache/shardingsphere/issues/28249#issuecomment-1692025575

   > 感谢你的回复，此问题已困扰数天 
   > 由于代码使用了普通文本编辑，导致github显示时缺少了一个下划线，但正确的创建规则依然无法多表绑定 
   >
   ```sql
    CREATE SHARDING TABLE RULE t_order( 
DATANODES("ds_0.t_order_${2023..2025}_0${1..9},ds_0.t_order_${2023..2025}_${10..12}"),
 AUDIT_STRATEGY (TYPE(NAME='DML_SHARDING_CONDITIONS'),ALLOW_HINT_DISABLE=TRUE));
    
    CREATE SHARDING TABLE RULE t_item ( 
DATANODES("ds_0.t_item_${2023..2025}_0${1..9},ds_0.t_item_${2023..2025}_${10..12}"),
 AUDIT_STRATEGY (TYPE(NAME="DML_SHARDING_CONDITIONS"),ALLOW_HINT_DISABLE=TRUE)
   ```
    
   > 生成的规则如下 
![image](https://user-images.githubusercontent.com/43465381/263035524-277dafae-c553-4b7d-bd2e-f616a49352bd.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