Bug #120365 Incorrect object type in note related to CREATE VIEW

• Submitted: 28 Apr 9:36
• Modified: 28 Apr 10:14
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Server: DDL
• Severity: S4 (Feature request)
• Version: 9.7.0
• OS: Any
• CPU Architecture: Any
• Tags: create view, VIEW

[28 Apr 9:36] Daniël van Eeden

Description:
mysql-9.7.0 [test]> CREATE VIEW IF NOT EXISTS v1 AS (SELECT 1);
Query OK, 0 rows affected, 1 warning (0.002 sec)

Note (Code 1050): Table 'v1' already exists
mysql-9.7.0 [test]> DROP TABLE v1;
ERROR 1051 (42S02): Unknown table 'test.v1'
mysql-9.7.0 [test]> DROP VIEW v1;
Query OK, 0 rows affected (0.001 sec)

I think the 1050 note should say that the *view* already exists, not that the *table* already exists

How to repeat:
Create a view with the new syntax and use a view name that already exists.