• unknown's avatar
    Bug #20482: failure on Create join view with sources views/tables in different · 6c787151
    unknown authored
                schemas
    The function check_one_table_access() called to check access to tables in 
    SELECT/INSERT/UPDATE was doing additional checks/modifications that don't hold
    in the context of setup_tables_and_check_access().
    That's why the check_one_table() was split into two : the functionality needed by
    setup_tables_and_check_access() into check_single_table_access() and the rest of 
    the functionality stays in check_one_table_access() that is made to call the new
    check_single_table_access() function.
    
    
    mysql-test/r/view_grant.result:
      Bug #20482: failure on Create join view with sources views/tables in different 
                  schemas
      - test suite for the bug
    mysql-test/t/view_grant.test:
      Bug #20482: failure on Create join view with sources views/tables in different 
                  schemas
      - test suite for the bug
    sql/mysql_priv.h:
      Bug #20482: failure on Create join view with sources views/tables in different 
                  schemas
      - check_one_table_access split into 2
    sql/sql_base.cc:
      Bug #20482: failure on Create join view with sources views/tables in different 
                  schemas
      - the new sub-function called
    sql/sql_parse.cc:
      Bug #20482: failure on Create join view with sources views/tables in different 
                  schemas
      - check_one_table_access() split into two : check_single_table_access() to 
        actually check access to the table(ro) and check_one_table_access() that calls
        check_single_table_access() and checks also the tables belonging to sub selects
        or implicitly opened tables.
    6c787151
sql_base.cc 164 KB