On Wed, May 05, 2004 at 06:44:09PM +0200, Mechain Marc wrote: > Hello, > > Why such a SQL request running well on the master is not correctly replicated on the > slave, > > set @providerId='012345'; > insert into DATA_TYPE values (1,@providerId,'DATA_TYPE',1); > > Here is an extract of the Slave Logfile: > > MYBCK.log.1:ERROR: 1048 Column 'PROVIDER_ID' cannot be null > MYBCK.log.1:040503 17:44:18 Slave: error 'Column 'PROVIDER_ID' cannot be null' on > query 'insert into DATA_TYPE values (1,@providerId,'DATA_TYPE',1)', error_code=1048 > > The question is: why is the value of @providerId not properly replicated ? > > Is it a bug ?
Them manual says that "user variables" don't replicate properly. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]