Comment 4 for bug 1441259

Arturas Moskvinas (arturas-w) wrote :

Muhammad - I was able to reproduce issue with my provided examples in bug description. I created tbl and tbl_postfix tables on master server, set super_read_only mode on on its' slave and executed:
'UPDATE tbl INNER JOIN tbl_postfix on tbl.id_ = tbl_postfix.tbl_id SET is_visible = 1 WHERE hex(tbl_postfix.postfix_id) LIKE 'yadada%' AND tbl.is_visible = 0'

Which immediately broke replication on slave:
               Last_SQL_Errno: 1290
               Last_SQL_Error: Error 'The MySQL server is running with the --read-only (super) option so it cannot execute this statement' on query. Default database: 'test'. Query: 'UPDATE tbl INNER JOIN tbl_postfix on tbl.id_ = tbl_postfix.tbl_id SET is_visible = 1 WHERE hex(tbl_postfix.postfix_id) LIKE 'yadada%' AND tbl.is_visible = 0'

Mysql version which we use: 5.6.21-70.1-698.precise