• unknown's avatar
    A test case for BUG#26676: VIEW using old table schema in a session. · 9395421a
    unknown authored
    The following clarification should be made in The Manual:
    
    Standard SQL is quite clear that, if new columns are added
    to a table after a view on that table is created with
    "select *", the new columns will not become part of the view.
    In all cases, the view definition (view structure) is frozen
    at CREATE time, so changes to the underlying tables do not
    affect the view structure.
    
    
    mysql-test/r/view.result:
      Update result file.
    mysql-test/t/view.test:
      Add a test case for BUG#26676: VIEW using old table schema in a session.
    9395421a
view.result 109 KB