Bug #74060 Bug with query cache views name

• Submitted: 25 Sep 2014 3:09
• Modified: 4 Aug 2017 6:49
• Reporter: Roberto Spadim (Basic Quality Contributor)
• Status: Won't fix
• Category: MySQL Server: Query Cache
• Severity: S1 (Critical)
• Version: any
• OS: Any
• CPU Architecture: Any

[25 Sep 2014 3:09] Roberto Spadim

Description:
https://mariadb.atlassian.net/browse/MDEV-6781

there's a bug at query cache view name
the patch is very easy
https://github.com/rspadim/server/commit/5a5e47bf4141ebc3584ed365173dde87b70e23a9

and i only found this problem using a qc_info plugin with more features from: 
https://mariadb.atlassian.net/browse/MDEV-4682

How to repeat:
use qc_info plugin from https://mariadb.atlassian.net/browse/MDEV-4682
clena query cache, create a view, execute a select, and check the name of view at information_Schema.query_cache_tables, or information_schema.query_cache_queries_tables

Suggested fix:
https://github.com/rspadim/server/commit/5a5e47bf4141ebc3584ed365173dde87b70e23a9

should use that corrrect line to mysql server

[4 Aug 2017 6:49] MySQL Verification Team

MySQL will no longer invest in the query cache, see:

http://mysqlserverteam.com/mysql-8-0-retiring-support-for-the-query-cache/

[4 Aug 2017 7:34] Hartmut Holzgraefe

With a patch that easy having been available for three years now that's a bit disappointing ...