• gshchepa/uchum@host.loc's avatar
    Fixed bug #35193. · 2dcec449
    gshchepa/uchum@host.loc authored
    View definition as SELECT ... FROM DUAL WHERE ... has
    valid syntax, but use of such view in SELECT or
    SHOW CREATE VIEW syntax causes unexpected syntax error.
    
    Server omits FROM DUAL clause when storing view body
    string in a .frm file for further evaluation.
    However, syntax of SELECT-witout-FROM query is more
    restrictive than SELECT FROM DUAL syntax, and doesn't
    allow the WHERE clause.
    
    NOTE: this syntax difference is not documented.
    
    
    View registration procedure has been modified to
    preserve original structure of view's body.
    2dcec449
sql_select.cc 500 KB