What happen if I drop aux_mysql extension while a mysql client connected

[movead123]

删除aux_mysql插件

halo0root=# drop extension aux_mysql cascade;
NOTICE: drop cascades to 2 other objects
DETAIL: drop cascades to table mysql.t1
drop cascades to table mysql.t2
DROP EXTENSION
halo0root=#

删除后的mysql客户端行为

_MySQL [mysql]> show tables;
ERROR 1146 (HY000): relation "mys_informa_schema.tables" does not exist
MySQL [mysql]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.001 sec)

MySQL [mysql]> select * from information_schema ;
ERROR 1146 (HY000): relation "information_schema" does not exist
MySQL [mysql]> \q
Bye
lchch@deepin:/data/pg_datas/openHalo/data$ mysql -P 3306 -h 127.0.0.1
ERROR 1049 (HY000): schema "mysql" does not exist
lchch@deepin:/data/pg_datas/openHalo/data$_

如果mysql模式正在被使用, 应该加个啥锁以此阻止插件被删除。

[Z-Xiao-M]

考虑在文档中说明，先将其转为讨论