• unknown's avatar
    Bug#25482 GRANT statements are not replicated if you use "replicate-ignore-table" · a5c60b3f
    unknown authored
     - GRANT and REVOKE statments didn't have the "updating" flag set and
       thus statements with a table specified would not replicate if
       slave filtering rules where turned on.
       For example "GRANT ... ON test.t1 TO ..." would not replicate.
    
    
    mysql-test/r/rpl_ignore_table.result:
      Add test results
    mysql-test/t/rpl_ignore_table.test:
      Add tests
    sql/sql_yacc.yy:
      Pass option TL_OPTION_UPDATING to 'add_table_to_list' when parsing a
      GRANT or REVOKE and a table specifier is found. This will set the
      property "updating" on the table and thus the slave filtering rules will 
      be applied.
      
      Without setting updating the statement will be not
      replicated - since "it's not updating anything" - an optimization
      to quickly skip SELECT's and similar.
    a5c60b3f
rpl_ignore_table.test 3.32 KB