Re: mysql 4.09 query cache bug

2003-02-14 Thread Sanja Byelkin
Hi! [skip] > When running a query like: > LOAD DATA CONCURRENT INFILE '...' REPLACE INTO TABLE l_data FIELDS > TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n' > (list_id,email,f1,f2,f3) [skip] Thank you for your bugreport. Now bug is fixed, here is patch: diff -Nrc a/sql/sql_load.cc

mysql 4.09 query cache bug

2003-02-05 Thread Corin Langosch
Hi! When running a query like: LOAD DATA CONCURRENT INFILE '...' REPLACE INTO TABLE l_data FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n' (list_id,email,f1,f2,f3) mysql seems to forget to invalidate the query cache, because added rows are not displayed in following SELECT stat