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/11/01 09:13:42 UTC

[GitHub] [shardingsphere] TeslaCN opened a new issue, #21884: SQL check failed, error message: Not allow DML operation without sharding conditions.

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

   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   
   master - 3a640cc9f5fd7e6cebd890c4c53f0fc612a73084
   
   But this may affect 5.2.0 and 5.2.1.
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   
   ShardingSphere-Proxy
   
   ### Expected behavior
   
   No error occur.
   
   ### Actual behavior
   
   The sharding conditions did existed. But error still occurred.
   ```
   SQL check failed, error message: Not allow DML operation without sharding conditions.
   ```
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   
   Just execute prepared statement with parameters.
   
   ```yaml
   rules:
     - !SHARDING
       # omit configurations
       auditors:
         sharding_key_required_auditor:
           type: DML_SHARDING_CONDITIONS
       tables:
         bmsql_warehouse:
           # omit table configurations
           auditStrategy:
             auditorNames:
               - sharding_key_required_auditor
             allowHintDisable: true
   ```


-- 
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] RaigorJiang closed issue #21884: SQL check failed, error message: Not allow DML operation without sharding conditions.

Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #21884: SQL check failed, error message: Not allow DML operation without sharding conditions.
URL: https://github.com/apache/shardingsphere/issues/21884


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