删除表失败, 点删除后什么反映也没有
mei-rune opened this issue · 10 comments
mei-rune commented
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
taozuhong commented
是指左侧的目录树没有刷新吗?
mei-rune commented
不是, 是库还在
注意,这个库名前面有一个空格, 是我输错了,想删除,结果删不了
taozuhong commented
哦, 可能是名字去掉了空格导致的问题。
mei-rune commented
你出个补丁, 我来试试
mei-rune commented
日志中这里有空格啊
DROP TABLE IF EXISTS tpt_test_for_handler
;
taozuhong commented
复制到编辑器中看了,日中也是没有空格,这是符合实际情况的,因为日志中输出的就是执行的SQL。
taozuhong commented
嗯,这个月出一个补丁版本修复这个问题。
taozuhong commented
亲,出现该问题的版本和数据库是啥?
我测试验证了 SQLite、MySQL、PostgreSQL都没问题,上下文如下:
袋鼠: 1.10.1.210731
MySQL: 5.7.30
PostgreSQL: 9.6.18
mei-rune commented
mysql 8.0
taozuhong commented