You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/07/12 06:59:49 UTC

[GitHub] [shardingsphere] natehuangting opened a new issue, #19058: allow broacast table update/delete limit ;

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

   ## Feature Request
   
   
   ```
   --- config-test.yaml
   
   schemaName: test
   
   dataSources:
     test_a:
       url: jdbc:mysql://127.0.0.1:3306/test?serverTimezone=Asia/Shanghai&useSSL=false&autoReconnect=true&characterEncoding=ISO-8859-1&zeroDateTimeBehavior=convertToNull
       username: test
       password: test
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 150
       minPoolSize: 0
     test_b:
       url: jdbc:mysql://127.0.0.1:3307/test?serverTimezone=Asia/Shanghai&useSSL=false&autoReconnect=true&characterEncoding=ISO-8859-1&zeroDateTimeBehavior=convertToNull
       username: test
       password: test
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 150
       minPoolSize: 0
   
   rules:
   - !SHARDING
     broadcastTables:
       - t_1
   
   
   
   
   -- How to reproduce:
   
   mysql> use test
   Database changed
   
   mysql> select * from t_1;
   Empty set (0.04 sec)
   
   mysql> update t_1 set id = 1 limit 1;
   ERROR 1997 (C1997): Runtime exception: [UPDATE ... LIMIT can not support sharding route to multiple data nodes.]
   ```
   


-- 
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.apache.org

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

[GitHub] [shardingsphere] terrymanu closed issue #19058: allow broacast table update/delete limit ;

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #19058: allow broacast table  update/delete limit ;
URL: https://github.com/apache/shardingsphere/issues/19058


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