Re: mysql 4.09 query cache bug

[Sanja Byelkin <suppressed>]

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 b/sql/sql_load.cc
*** a/sql/sql_load.cc   Fri Feb 14 22:21:22 2003
--- b/sql/sql_load.cc   Fri Feb 14 22:21:22 2003
***************
*** 336,341 ****
--- 336,342 ----
    }
    if (transactional_table)
      error=ha_autocommit_or_rollback(thd,error);
+   query_cache_invalidate3(thd, table_list, 0);

  err:
    if (thd->lock)

-- 
For technical support contracts, visit https://order.mysql.com/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Oleksandr Byelkin <suppressed>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
/_/  /_/\_, /___/\___\_\___/   Lugansk, Ukraine
       <___/   www.mysql.com

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <suppressed>
To unsubscribe, e-mail <suppressed>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php