Hi List, Anyone know what the problem is with the mysql query cache not flushing cache properly (see snip below)?
Is this a bug or am I missing something here? I'm using Mysql Standard 4.0.9-gamma on Linux (x86, libc6) Any help would be appreciated, Cheers, Andrew -------------start snip------------------------- mysql> select * from andrew; +----------+--------+------------+-------+----+------+------+--------+------ +------+ | event_id | title | venue_name | price | pc | x | y | wibble | lon | lat | +----------+--------+------------+-------+----+------+------+--------+------ +------+ | NULL | wibble | | | | NULL | NULL | | NULL | NULL | +----------+--------+------------+-------+----+------+------+--------+------ +------+ 1 row in set (0.05 sec) mysql> alter table andrew rename as andrew_blah; Query OK, 0 rows affected (0.02 sec) mysql> select * from andrew; +----------+--------+------------+-------+----+------+------+--------+------ +------+ | event_id | title | venue_name | price | pc | x | y | wibble | lon | lat | +----------+--------+------------+-------+----+------+------+--------+------ +------+ | NULL | wibble | | | | NULL | NULL | | NULL | NULL | +----------+--------+------------+-------+----+------+------+--------+------ +------+ 1 row in set (0.00 sec) --------------end snip------------------------- Query,sql --------------------------------------------------------------------- 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
