taojintianxia edited a comment on issue #9568: URL: https://github.com/apache/shardingsphere/issues/9568#issuecomment-844999160
hi , there following is the process I try to test the RQL 1. I launched up 3 containers through docker compose, MySQL-A, MySQL-B, zookeeper 2. switch the option `return context.getSqlStatement() instanceof DDLStatement;` in ExecuteProcessStrategyEvaluator.java 3. compiled the shardingsphere project and unzip the proxy districution 4. edit the config-sharding.yaml and luanch up proxy 5. insert 2 million records by sysbench prepare ```shell sysbench oltp_read_only --mysql-host=127.0.0.1 --mysql-port=3307 --mysql-user=root --mysql-password='root' --mysql-db=sbtest --tables=10 --table-size=2000000 --report-interval=30 --time=180 --threads=16 --max-requests=0 --percentile=99 --mysql-ignore-errors="all" --range_selects=off --rand-type=uniform --auto_inc=off prepare ``` this is the structure of test table  6.try to delete one collumn by alter table clause ```sql alter table sbtest1 drop c; ``` 7. since there are a lot of record in that table, this takes time.... in the meanwhile ..... open another console to proxy and execute following command : ```shell show processlist; ```  we could see that the `Time` is increasing, and when the alter table finished , the `show processlist` returns empty and when the alter table executing, in zookeeper, we could see the `executionnode`  when alter table finished , there is no such node in zookeeper. -- 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. For queries about this service, please contact Infrastructure at: [email protected]
