[Sqlrelay-discussion] sqlrelay-mysql mapping
Brought to you by:
mused
|
From: Sekou A. <sek...@to...> - 2007-04-27 16:51:02
|
It appears that the query tag in sqlrelay.conf file is CASE SENSITIVE. I have a working config where DML/DDL are going to "master" and other queries are going to "slave" however I notice that the reults of the select query when presented as a list of comma separated values is actually merging the reults of two columns. This is causing UPDATES where columns are presented with wrong values eg results like=20 NULLNULL instead of NULL,NULL NULL"0" instead of NULL,"0" NULL"" instead of NULL,"" Is there some way to resolve this, it appears to be formating related=20 S. Sekou Abodunrin=20 =09 This email is confidential and may also be privileged. If you are not = the intended recipient please notify us immediately by telephoning +44 = (0)20 7452 5300 or email pos...@to.... You should not copy = it or use it for any purpose nor disclose its contents to any other = person. Touch Local cannot accept liability for statements made which = are clearly the sender's own and are not made on behalf of the firm. Touch Local Limited Registered Number: 2885607 VAT Number: GB896112114 Cardinal Tower, 12 Farringdon Road, London EC1M 3NN +44 (0)20 7452 5300 |