dbkangaroo/kangaroo

删除表失败, 点删除后什么反映也没有

mei-rune opened this issue · 10 comments

15:28:44.419   register GUI log handler.
15:28:57.853   SQL: DROP TABLE IF EXISTS ` tpt_test_for_handler`;
15:28:57.898   affected rows: 0
15:28:57.899   SQL: SELECT table_name, table_schema, engine FROM information_schema.tables WHERE table_schema = 'test' AND table_type LIKE '%TABLE%' ORDER BY table_name;
15:28:57.904   affected rows: 6
15:28:57.907   SQL: SELECT table_name, table_schema, engine FROM information_schema.tables WHERE table_schema = 'test' AND table_type LIKE '%VIEW%' ORDER BY table_name;
15:28:57.910   affected rows: 0
15:29:17.996   SQL: DROP TABLE IF EXISTS ` tpt_test_for_handler`;
15:29:18.036   affected rows: 0
15:29:18.036   SQL: SELECT table_name, table_schema, engine FROM information_schema.tables WHERE table_schema = 'test' AND table_type LIKE '%TABLE%' ORDER BY table_name;
15:29:18.040   affected rows: 6
15:29:24.036   SQL: SELECT table_name, table_schema, engine FROM information_schema.tables WHERE table_schema = 'test' AND table_type LIKE '%TABLE%' ORDER BY table_name;
15:29:24.041   affected rows: 6
15:32:14.732   SQL: SELECT table_name, table_schema, engine FROM information_schema.tables WHERE table_schema = 'test' AND table_type LIKE '%TABLE%' ORDER BY table_name;
15:32:14.738   affected rows: 6

是指左侧的目录树没有刷新吗?

不是, 是库还在

注意,这个库名前面有一个空格, 是我输错了,想删除,结果删不了

哦, 可能是名字去掉了空格导致的问题。

你出个补丁, 我来试试

日志中这里有空格啊

DROP TABLE IF EXISTS tpt_test_for_handler;

复制到编辑器中看了,日中也是没有空格,这是符合实际情况的,因为日志中输出的就是执行的SQL。

嗯,这个月出一个补丁版本修复这个问题。

亲,出现该问题的版本和数据库是啥?

我测试验证了 SQLite、MySQL、PostgreSQL都没问题,上下文如下:
袋鼠: 1.10.1.210731
MySQL: 5.7.30
PostgreSQL: 9.6.18

mysql 8.0

image
image

MySQL 8.0.20 测试没问题呀