Definer for SP or function is not replicated

Bug #923455 reported by Seppo Jaakola
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Fix Released
Medium
Seppo Jaakola
5.5
Fix Released
Medium
Seppo Jaakola

Bug Description

To reproduce, create a simple procedure:

mysql> create procedure foo42() insert into test.z values (1, 42);
Query OK, 0 rows affected (0.00 sec)

mysql> select * from mysql.proc\G
*************************** 1. row ***************************
                  db: test
                name: foo42
                type: PROCEDURE
       specific_name: foo42
            language: SQL
     sql_data_access: CONTAINS_SQL
    is_deterministic: NO
       security_type: DEFINER
          param_list:
             returns:
                body: insert into test.z values (1, 42)
             definer: root@%
             created: 2012-01-29 20:23:36
            modified: 2012-01-29 20:23:36
            sql_mode:
             comment:
character_set_client: utf8
collation_connection: utf8_general_ci
        db_collation: latin1_swedish_ci
           body_utf8: insert into test.z values (1, 42)
1 row in set (0.00 sec)

in slave:

mysql> select * from mysql.proc\G

*************************** 1. row ***************************
                  db: test
                name: foo42
                type: PROCEDURE
       specific_name: foo42
            language: SQL
     sql_data_access: CONTAINS_SQL
    is_deterministic: NO
       security_type: DEFINER
          param_list:
             returns:
                body: insert into test.z values (1, 42)
             definer: @
             created: 2012-01-29 20:11:48
            modified: 2012-01-29 20:11:48
            sql_mode:
             comment:
character_set_client: utf8
collation_connection: utf8_general_ci
        db_collation: latin1_swedish_ci
           body_utf8: insert into test.z values (1, 42)
1 row in set (0.11 sec)

Related branches

Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.