Bug #824 queries with leading comment will not fetched from query cache
Submitted: 10 Jul 2003 1:05 Modified: 18 Jul 2003 6:47
Reporter: Oleksandr Byelkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0 OS:Any (any)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[10 Jul 2003 1:05] Oleksandr Byelkin 
Description:
queries with leading comment will not fetched from query cache 

How to repeat:
create table t1 (a int); 
/**/ select * from t1; 
/**/ select * from t1; 
show status like "Qcache_hits";
[10 Jul 2003 1:32] Oleksandr Byelkin 
ChangeSet 
  1.1513 03/07/10 11:30:51 bell@sanja.is.com.ua +3 -0 
  fixed BUG#824 
  now all queries with first character '/' will be looked up in query cache to 
avoid skiping SELECTs with leading comment 
  as far as such queries is not frequently used big overhead is not expected
[18 Jul 2003 6:47] Oleksandr Byelkin 
fixed in 5.0