bug Percona 5.5.20 - replication binary log

02-16-2012, 12:44 AM

Hi guys

I think I have come across a bug - I havent confirmed whether this is a MySQL bug or a Percona bug.

Summary of bug
****************
When binary log ignore DB is set, without first using a database schema and running a fully quantified SQL statement specifying the schema database and table in the SQL (eg insert into foo.bar values('test') the change statement isnt written to the binary log file.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> insert into testbinlog.testtable vaules (NULL);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'vaules (NULL)' at line 1
mysql> insert into testbinlog.testtable values (NULL);
Query OK, 1 row affected (0.00 sec)