不支持show all tables语法

[yejr]

• dble version：
  5.7.11-dble-3.22.07.0-891dd27f53e35a30166179d79d1dfadd5f2719da-20220915062343

• 安装方式 参考文档：https://github.com/actiontech/dble-docs-cn/blob/master/0.overview/0.3_quick_start/0.3.1_dble_quick_start_docker.md 安装过程：

docker network create -o "com.docker.network.bridge.name"="dble-net" --subnet 172.18.0.0/16 dble-net

docker run --name backend-mysql1 --ip 172.18.0.2 -e MYSQL_ROOT_PASSWORD=123456 -p 33061:3306 --network=dble-net -d mysql:5.7 --server-id=1

docker run --name backend-mysql2 --ip 172.18.0.3 -e MYSQL_ROOT_PASSWORD=123456 -p 33062:3306 --network=dble-net -d mysql:5.7 --server-id=2

sleep 30

docker run -d -i -t --name dble-server --ip 172.18.0.5 -p 8066:8066 -p 9066:9066 --network=dble-net actiontech/dble:latest

执行SQL报错：

# 连接dble
mysql -P8066 -u root -p123456 -h 127.0.0.1

# 执行sql
mysql> root@[testdb]>show tables;
+----------------------+
| Tables_in_testdb     |
+----------------------+
| tb_child1            |
...
| tb_uneven_hash       |
+----------------------+
21 rows in set (0.00 sec)

# 执行show all tables报错
mysql> show all tables;
ERROR 1064 (HY000): druid not support sql syntax, the reason is syntax error: syntax error, error in :' all tables', expect CREATE, actual null, pos 15, line 1, column 10, token IDENTIFIER tables

[PanternBao]

please join QQ group 669663113 to communicate

[yanhuqing666]

“druid not support sql syntax”...so can not support for now， but I remember it worked good and I will check the problem

[PanternBao]

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