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

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


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

   感谢你的回复，此问题已困扰数天
   多次测试导致语句拷贝错误，但正确的规则语句依然无法绑定表
   
   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://github.com/apache/shardingsphere/assets/43465381/277dafae-c553-4b7d-bd2e-f616a49352bd)
   


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