Bug #14714 can't create views on show sentences
Submitted: 7 Nov 2005 17:46 Modified: 9 Nov 2005 16:37
Reporter: Adrian Spinetta Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: Views Severity:S2 (Serious)
Version:5.0.15 OS:Microsoft Windows (windows xp)
Assigned to: CPU Architecture:Any

[7 Nov 2005 17:46] Adrian Spinetta
I can't create a view on show commands.

How to repeat:
create view test.myslave as show slave status;
or also

create algorithm=merge definer ='%'@'localhost' sql security invoker
 view test.myslave as show slave status;

create view test.myslave as show tables;

Suggested fix:
I can't find any restriction in the manual for this.
[9 Nov 2005 16:37] MySQL Verification Team
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

The syntax is:

CREATE VIEW ... view_name AS select_statement

select_statement means "SELECT".  SHOW  isn't legal according to the documentation.