query cache bug (4.1)

Hi,

how-to-repeat:

Version: MySQL 4.1 (latest changeset 1.424)

mysql> create table a (a int);
Query OK, 0 rows affected (0.01 sec)

mysql> insert into a values (1),(2);
Query OK, 2 rows affected (0.02 sec)
Records: 2 Duplicates: 0 Warnings: 0

mysql> select a from a;
+------+
| a |
+------+
| 1 |
| 2 |
+------+
2 rows in set (0.04 sec)

mysql> alter table a rename b;
Query OK, 0 rows affected (0.03 sec)

mysql> select * from a;
ERROR 1146: Table 'test.a' doesn't exist

mysql> select a from a;
+------+
| a |
+------+
| 1 |
| 2 |
+------+
2 rows in set (0.00 sec)

Looks like 2nd query is still cached.

Regards

Georg

------------------------------------------------------------ ---------
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 bugs-thread13566@lists.mysql.com
To unsubscribe, e-mail

Re: query cache bug (4.1)

Hi!

On Thu, Jan 23, 2003 at 10:38:19PM +0100, Georg Richter wrote:
> Hi,
>
> how-to-repeat:
>
> Version: MySQL 4.1 (latest changeset 1.424)
>
> mysql> create table a (a int);
> Query OK, 0 rows affected (0.01 sec)
>
> mysql> insert into a values (1),(2);
> Query OK, 2 rows affected (0.02 sec)
> Records: 2 Duplicates: 0 Warnings: 0
>
> mysql> select a from a;
> +------+
> | a |
> +------+
> | 1 |
> | 2 |
> +------+
> 2 rows in set (0.04 sec)
>
> mysql> alter table a rename b;
> Query OK, 0 rows affected (0.03 sec)
>
> mysql> select * from a;
> ERROR 1146: Table 'test.a' doesn't exist
>
> mysql> select a from a;
> +------+
> | a |
> +------+
> | 1 |
> | 2 |
> +------+
> 2 rows in set (0.00 sec)
>
> Looks like 2nd query is still cached.
>
> Regards
>
> Georg

Thank you for bug report, but this bug was fixed this night.
(patch is committed and pushed (1.1523))

--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin
/ /|_/ / // /\ \/ /_/ / /__ 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 bugs-thread13569@lists.mysql.com
To unsubscribe, e-mail