> I've seen a strange replication problem with MySQL v4.0.12.
>
> mysql> LOAD DATA LOCAL INFILE '/home/andrew/upload' into table andrew FIELDS
> TERMINATED BY ',' lines terminated by '\n';
Hi,
This bug is fixed in MySQL 4.0.13 (not released yet).
Until then a patch for this is :
===== sql/log_event.cc 1.96 vs edited =====
*** /tmp/log_event.cc-1.96-14055 Sat Jan 18 20:00:24 2003
--- edited/sql/log_event.cc Tue Mar 25 18:29:16 2003
***************
*** 1858,1863 ****
--- 1858,1868 ----
String line_term(sql_ex.line_term,sql_ex.line_term_len);
String line_start(sql_ex.line_start,sql_ex.line_start_len);
String escaped(sql_ex.escaped,sql_ex.escaped_len);
+ ex.field_term= &field_term;
+ ex.enclosed= &enclosed;
+ ex.line_term= &line_term;
+ ex.line_start= &line_start;
+ ex.escaped= &escaped;
ex.opt_enclosed = (sql_ex.opt_flags & OPT_ENCLOSED_FLAG);
if (sql_ex.empty_flags & FIELD_TERM_EMPTY)
Regards,
Guilhem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
