Yes, sql_mode is blank on all server A, B, C On Wed, Jan 21, 2009 at 8:40 PM, John Daisley < john.dais...@mypostoffice.co.uk> wrote:
> Is the sql_mode set the same on A/B/C? > > > > > Why are A and B letting you cram NULL into a column declared NOT NULL? > > > > > > > > Are your schemas consistent on A/B/C? > > > > > > > > Perhaps 5.0.32 does not enforce NOT NULL properly? > > > > Some tweak to config may change this? > > > > > > > > I don't know the answer, but with a bit of research in this direction, > you > > should be there. > > > > > > > > In other words: > > > > Forget the replication part -- Focus on the NULL in a NOT NULL column > > part. > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk > > > > > > ______________________________________________ > > This email has been scanned by Netintelligence > > http://www.netintelligence.com/email > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com > > -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 500003 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: prajapat...@gmail.com
