Bug in InnoDB and query cache in MySQL-4.1

Hi,

After pulling the latest changeset (including the merge from 4.0 tree), I'm
experiencing problems with InnoDB when the query cache is enabled.
How-to-repeat :

CREATE TABLE `cookie` (
`pseudo` varchar(35) character set latin1 NOT NULL default ''
) TYPE=InnoDB

INSERT INTO cookie (pseudo) VALUES ('test'),('test1');
SELECT * FROM cookie;
+--------+
| pseudo |
+--------+
| test |
| test1 |
+--------+
2 rows in set (0.00 sec)

mysql> UPDATE cookie SET pseudo='jocelyn' WHERE pseudo='test';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT * FROM cookie;
+--------+
| pseudo |
+--------+
| test |
| test1 |
+--------+
2 rows in set (0.00 sec)


mysql> RESET QUERY CACHE;
Query OK, 0 rows affected (0.03 sec)

mysql> SELECT * FROM cookie;
+---------+
| pseudo |
+---------+
| jocelyn |
| test1 |
+---------+
2 rows in set (0.00 sec)

Regards,
Jocelyn


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

Re: Bug in InnoDB and query cache in MySQL-4.1

Hi!

On Sat, Nov 23, 2002 at 09:20:01AM -0000, Jocelyn Fournier wrote:
> Hi,
>
> After pulling the latest changeset (including the merge from 4.0 tree), I'm
> experiencing problems with InnoDB when the query cache is enabled.
> How-to-repeat :
>
> CREATE TABLE `cookie` (
> `pseudo` varchar(35) character set latin1 NOT NULL default ''
> ) TYPE=InnoDB
>
> INSERT INTO cookie (pseudo) VALUES ('test'),('test1');
> SELECT * FROM cookie;
> +--------+
> | pseudo |
> +--------+
> | test |
> | test1 |
> +--------+
> 2 rows in set (0.00 sec)
>
> mysql> UPDATE cookie SET pseudo='jocelyn' WHERE pseudo='test';
> Query OK, 1 row affected (0.01 sec)
> Rows matched: 1 Changed: 1 Warnings: 0
>
> mysql> SELECT * FROM cookie;
> +--------+
> | pseudo |
> +--------+
> | test |
> | test1 |
> +--------+
> 2 rows in set (0.00 sec)
>
>
> mysql> RESET QUERY CACHE;
> Query OK, 0 rows affected (0.03 sec)
>
> mysql> SELECT * FROM cookie;
> +---------+
> | pseudo |
> +---------+
> | jocelyn |
> | test1 |
> +---------+
> 2 rows in set (0.00 sec)
>

Thank you for bug report. It is known bug and it is already fixed in 4.0
yesterday. It will be fixed in 4.1 after merging it with 4.0 again.

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