• unknown's avatar
    Fixed bug#21261: Wrong access rights was required for an insert into a view · f7f5bf63
    unknown authored
    SELECT right instead of INSERT right was required for an insert into to a view.
    This wrong behaviour appeared after the fix for bug #20989. Its intention was
    to ask only SELECT right for all tables except the very first for a complex
    INSERT query. But that patch has done it in a wrong way and lead to asking 
    a wrong access right for an insert into a view.
    
    The setup_tables_and_check_access() function now accepts two want_access
    parameters. One will be used for the first table and the second for other
    tables.
    
    
    mysql-test/t/view.test:
      Added a test case for bug#21261: Wrong access rights was required for an insert into a view
    mysql-test/r/view.result:
      Added a test case for bug#21261: Wrong access rights was required for an insert into a view
    sql/sql_update.cc:
      Fixed bug#21261: Wrong access rights was required for an insert into a view
      Modified to use updated setup_tables_and_check_access() function.
    sql/sql_select.cc:
      Fixed bug#21261: Wrong access rights was required for an insert into a view
      Modified to use updated setup_tables_and_check_access() function.
    sql/sql_load.cc:
      Fixed bug#21261: Wrong access rights was required for an insert into a view
      Modified to use updated setup_tables_and_check_access() function.
    sql/sql_insert.cc:
      Fixed bug#21261: Wrong access rights was required for an insert into a view
      Modified to use updated setup_tables_and_check_access() function.
    sql/sql_delete.cc:
      Fixed bug#21261: Wrong access rights was required for an insert into a view
      Modified to use updated setup_tables_and_check_access() function.
    sql/sql_base.cc:
      Fixed bug#21261: Wrong access rights was required for an insert into a view
      The setup_tables_and_check_access() function now accepts two want_access
      parameters. One will be used for the first table and the second for other
      tables.
    sql/mysql_priv.h:
      Fixed bug#21261: Wrong access rights was required for an insert into a view
      The setup_tables_and_check_access() function now accepts two want_access
      parameters.
    f7f5bf63
sql_insert.cc 88 KB