Re: MySQL Binlog/Replication and SET @variables

2005-06-24 Thread Gleb Paharenko
Hello. It seems like a documented bug. Switch to 4.1.12. See: http://dev.mysql.com/doc/mysql/en/replication-features.html Markus Benning <[EMAIL PROTECTED]> wrote: > Hello, > > i have a problem with my replication setup and SET statments. > The SET statments seem to be not logge

Re: MySQL Binlog/Replication and SET @variables

2005-06-24 Thread Ware Adams
On Jun 24, 2005, at 10:56 AM, Markus Benning wrote: i have a problem with my replication setup and SET statments. The SET statments seem to be not logged with the queries. This is a replication limitation in versions prior to 4.1: Update statements that refer to user variables (that is, varia

MySQL Binlog/Replication and SET @variables

2005-06-24 Thread Markus Benning
Hello, i have a problem with my replication setup and SET statments. The SET statments seem to be not logged with the queries. An example: CREATE TABLE blablub (ID INT NOT NULL auto_increment PRIMARY KEY, bla text, blub text); SET @bla='bla'; SET @blub='blub'; INSERT INTO blablub VALUES(NULL, @