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, variables of the form @var_name) are badly replicated in 3.23 and 4.0. This is fixed in 4.1. Note that user variable names are case insensitive starting from MySQL 5.0. You should take this into account when setting up replication between 5.0 and an older version.

http://dev.mysql.com/doc/mysql/en/replication-features.html

--Ware

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to