Bug #1324 query cache doesn't work in embedded mysql
Submitted: 17 Sep 2003 15:07 Modified: 7 Jan 2004 3:46
Reporter: Georg Richter Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Embedded Library ( libmysqld ) Severity:S3 (Non-critical)
Version:4.1.1 OS:Linux (Linux)
Assigned to: Alexey Botchkov CPU Architecture:Any

[17 Sep 2003 15:07] Georg Richter 
Description:
libmysqld doesn't like query cache :) 

How to repeat:
~/.my.cnf: 
[server] 
datadir=. 
skip-innodb 
query_cache_size=32M 
 
.... 
 
mysql_query(mysql, "SELECT foo from bar"); 
mysql_query(mysql, "SELECT foo from bar"); 
 
Output: 
test_embedded: sql_cache.cc:907: int Query_cache::send_result_to_client(THD*, char*, 
unsigned int): Assertion `thd->net.query_cache_query == 0' failed. 
 

Suggested fix:
[12 Nov 2003 5:31] Alexey Botchkov 
bk commit - 4.1 tree (1.1600)
[20 Dec 2003 19:27] Alex Zimnitski 
cache doesn't work when query result size is more than 900Kb. 
cache works when query result size is less than 1Kb. 
OS:Windows
Version: 4.1.0-alpha-max-nt
[7 Jan 2004 3:45] Alexey Botchkov 
to the last note:
query cache doesn't store results if they're bigger than
query_cache_limit value.
[7 Jan 2004 3:46] Alexey Botchkov 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html