Query cache is not used for tables or databases with dots in their names
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
New
|
Undecided
|
Unassigned |
Bug Description
I've confirmed this bug with mariadb 5.1.49 from our delta rep for lucid (5.1.49-mariadb82) it is not present on mysql 5.1.41 on lucid (5.1.41-
Can be replicated as follows
MariaDB [(none)]> CREATE DATABASE `foo.bar`;
Query OK, 1 row affected (0.00 sec)
MariaDB [(none)]> use foo.bar;
Database changed
MariaDB [foo.bar]> CREATE TABLE moocow (a int);
Query OK, 0 rows affected (0.01 sec)
MariaDB [foo.bar]> SHOW STATUS LIKE 'Qcache%';
+------
| Variable_name | Value |
+------
| Qcache_free_blocks | 1 |
| Qcache_free_memory | 268415928 |
| Qcache_hits | 1 |
| Qcache_inserts | 1 |
| Qcache_
| Qcache_not_cached | 15311 |
| Qcache_
| Qcache_total_blocks | 4 |
+------
8 rows in set (0.00 sec)
MariaDB [foo.bar]> INSERT INTO moocow VALUES (1), (2), (3);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
MariaDB [foo.bar]> SELECT * FROM moocow;
+------+
| a |
+------+
| 1 |
| 2 |
| 3 |
+------+
3 rows in set (0.00 sec)
MariaDB [foo.bar]> SHOW STATUS LIKE 'Qcache%';
+------
| Variable_name | Value |
+------
| Qcache_free_blocks | 1 |
| Qcache_free_memory | 268415928 |
| Qcache_hits | 1 |
| Qcache_inserts | 1 |
| Qcache_
| Qcache_not_cached | 15312 |
| Qcache_
| Qcache_total_blocks | 4 |
+------
8 rows in set (0.00 sec)
Changed in maria: | |
milestone: | none → 5.1 |
So this is effectively a regression then, since an older (upstream) codebase does not exhibit the problem.
Of course it's utterly nasty to have table names with dots in them, but since it's allowed...