Thank you very much for the speedy response. Because of your positive attitude I'm going to try and talk my boss into purchasing a few MySQL licences to help you with development. (the query caching has effectively helped us to reduce hardware costs as 65% of our queries are coming out of memory and not hitting the disks (and I'm talking about thousands of queries per second)).
Thanks again, Andrew Sql,query -----Original Message----- From: Sanja Byelkin [mailto:[EMAIL PROTECTED]] Sent: 23 January 2003 23:56 To: Andrew Braithwaite Cc: [EMAIL PROTECTED] Subject: query cache not working with alter table rename as... Hi! Thank you for bugreport. This bug is fixed now. Here is patch for it: diff -Nrc a/sql/sql_table.cc b/sql/sql_table.cc *** a/sql/sql_table.cc Fri Jan 24 01:54:55 2003 --- b/sql/sql_table.cc Fri Jan 24 01:54:55 2003 *************** *** 1432,1437 **** --- 1432,1439 ---- } send_ok(&thd->net); } + table_list->table=0; // For query cache + query_cache_invalidate3(thd, table_list, 0); DBUG_RETURN(error); } -- Regards, Alexander --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php