shubham-j-sde commented on issue #30974: URL: https://github.com/apache/shardingsphere/issues/30974#issuecomment-2084796945
Hi, I tried to analyze this bug, I think that the `CALL` parser is actually working fine, the real issue seems that `sys` and `mysql` have no procedures when using shardingsphere as host. I took both db's as datasources on `sharding_db`. So, here the procedure is parced and executed correctly. For the later, `sp_migrate_firewall_user_to_group` actually requires A server-side plugin named **MYSQL_FIREWALL** needs to be installed. and selected db needs to be `mysql` to [execute](https://dev.mysql.com/doc/refman/8.0/en/firewall-reference.html#:~:text=To%20invoke%20a%20firewall%20stored%20procedure). and `query_rewrite.flush_rewrite_rules` [requires](https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html#:~:text=query_rewrite%20database.) A server-side plugin named **Rewriter**. <img width="1440" alt="Screenshot 2024-04-30 at 2 22 08 PM" src="https://github.com/apache/shardingsphere/assets/70763025/3b4b7f75-f666-477f-a8ee-ba9f35e98305";> <img width="1440" alt="Screenshot 2024-04-30 at 2 35 10 PM" src="https://github.com/apache/shardingsphere/assets/70763025/111ce0e3-2737-428a-975f-857d12bb43af";> -- 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]
