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:
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
libmysqld doesn't like query cache :) 

How to repeat:
mysql_query(mysql, "SELECT foo from bar"); 
mysql_query(mysql, "SELECT foo from bar"); 
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. 
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