Collapsar

please refer : https://dev.mysql.com/doc/refman/8.0/en/correlated-subqueries.html, subquery like this doesn't support. You can replace sql with join or other way.

can join QQGroup 669663113 to communicate

refer to https://github.com/actiontech/dble/discussions/3425

please join QQ group 669663113 to communicate

The root user may configure blacklist in user.xml, you can remove blacklist to retry.

fix by: https://github.com/actiontech/dble/pull/1349