Details
-
Technical task
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
None
-
None
Description
MariaDB [test]> create or replace view v1 as select 1; |
Query OK, 0 rows affected (0.08 sec) |
|
MariaDB [test]> create or replace table v1 as select 1; |
ERROR 1051 (42S02): Unknown table 'test.v1' |
There should probably be some error, but not "Unknown table", because it's confusing.
Fixed by creating a new error message:
"xxxx" is a view
This will be given both in "drop table this_is_a_view' and 'create or replace this_is_a_view...'