Bug #5162 Views: name is not delimited in SHOW CREATE VIEW
Submitted: 23 Aug 2004 1:49 Modified: 25 Aug 2004 9:04
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.2-alpha-debug OS:Linux (SuSE 8.2)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[23 Aug 2004 1:49] Peter Gulutzan 
Description:
MySQL usually puts identifiers inside delimiters 
i.e. ``s. But if I start in ANSI mode, I don't see 
them for the view name itself. For example I see 
CREATE VIEW db5.view 15 AS select 5 AS `5` 
And not 
CREATE VIEW `db5`.`view 15` AS select 5 AS `5` 
This doesn't cause any trouble. A very minor thing. 

How to repeat:
mysql> create view "view 15" as select 5; 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> show create view "view 15"; 
+---------+--------------------------------------------+ 
| Table   | Create Table                               | 
+---------+--------------------------------------------+ 
| view 15 | CREATE VIEW db5.view 15 AS select 5 AS `5` | 
+---------+--------------------------------------------+ 
1 row in set (0.00 sec)
[24 Aug 2004 22:09] Oleksandr Byelkin 
ChangeSet 
  1.1733 04/08/24 23:07:34 bell@sanja.is.com.ua +3 -0 
  fixes name outout for SHOW CREATE VIEW command (BUG#5162)
[25 Aug 2004 9:04] Oleksandr Byelkin 
Thank you for bugreport! 
Bug is fixed, patch is pushed in our source repository.