Bug #51387 The syntax element "column_list" in CREATE VIEW has not been specified.
Submitted: 22 Feb 2010 13:18 Modified: 22 Feb 2010 13:31
Reporter: Horst Hunger Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.5.99-m3-debug OS:Any
Assigned to: CPU Architecture:Any

[22 Feb 2010 13:18] Horst Hunger 
Description:
This is the specification of CREATE VIEW:

CREATE
    [OR REPLACE]
    [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
    [DEFINER = { user | CURRENT_USER }]
    [SQL SECURITY { DEFINER | INVOKER }]
    VIEW view_name [(column_list)]
    AS select_statement
    [WITH [CASCADED | LOCAL] CHECK OPTION]

In the whole Reference manual the syntax element hsa not been specified. So, what is it exactly? 

How to repeat:
Reference manual for 5.4, 12.1.16

Suggested fix:
Look at CREATE TABLE specification:

CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
    (create_definition,...)
    [table_options]
    [partition_options]

create_definition:
    col_name column_definition
  | [CONSTRAINT [symbol]] PRIMA

So, is 

column_list:
    col_name column_definition
?
[22 Feb 2010 13:20] Horst Hunger 
Sorry, have forgotten the points:

So, is 

column_list:
    col_name column_definition,...
?
[22 Feb 2010 13:31] Horst Hunger 
Found the specification.