error message when calling `drop table` on a view doesn't make sense

[angelamayxie]

mysql

mysql> drop table v;
ERROR 1051 (42S02): Unknown table 'db.v'
mysql> drop view v;
Query OK, 0 rows affected (0.01 sec)

dolt

tmp/main*> drop table v;
Unknown table 't_2'
tmp/main*> drop view v;
Empty set (0.01 sec)

while t_2 is a table that view v references, it is a known table and also not the name of the object being dropped.

[angelamayxie]

t_2 and v were created with the following queries

CREATE TABLE t_2 (id BINARY(2), status TINYINT UNSIGNED DEFAULT 0, other BINARY(2));
CREATE VIEW v AS SELECT t_2.id, status FROM t_2;

[jiangmuran]

I can take this. Plan: detect when DROP TABLE targets a view and return the expected table-not-found error instead of leaking a referenced table name. Will send a small PR with a test.

[angelamayxie]

@jiangmuran Okay! The change you'll need to make would be in dolthub/go-mysql-server and you can add the test to view_queries.go