Bug #17656 | Perform Check for User before Creating Views in info_schema.views | ||
---|---|---|---|
Submitted: | 22 Feb 2006 23:32 | Modified: | 3 Jan 2007 9:57 |
Reporter: | Chris Calender | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Views | Severity: | S4 (Feature request) |
Version: | OS: | ||
Assigned to: | CPU Architecture: | Any |
[22 Feb 2006 23:32]
Chris Calender
[26 Dec 2006 13:03]
Valeriy Kravchuk
Thank you for a reasonable feature request. Now, in 5.0.34-BK, we have the following behaviour: mysql> create definer='unknown'@'locahost' view vvuu as select 1; Query OK, 0 rows affected, 1 warning (0.01 sec) mysql> show warnings\G *************************** 1. row *************************** Level: Note Code: 1449 Message: There is no 'unknown'@'locahost' registered 1 row in set (0.01 sec) mysql> select version(); +--------------+ | version() | +--------------+ | 5.0.34-debug | +--------------+ 1 row in set (0.00 sec) So, maybe we just need new SQL mode that will treat this as error, not simply as warning. Please, check is there is still any need to implement something related to this feature request.