MySQL Bugs: #42565: ndb_cache_trans failure since SERVER_STATUS_IN

Bug #42565	ndb_cache_trans failure since SERVER_STATUS_IN_TRANS added to hash key
Submitted:	3 Feb 12:40
Reporter:	Magnus Blaudd
Status:	Verified
Category:	Server: Cluster	Severity:	S3 (Non-critical)
Version:	mysql-6.0	OS:	Any
Assigned to:	Davi Arnaut	Target Version:
Tags:	ndb, autocommit, query cache, disabled
Triage:	Triaged: D3 (Medium) / R6 (Needs Assessment) / E6 (Needs Assessment)

View
Add Comment
Files
Developer
Edit Submission
View Progress Log

Description:
When merging down MySQL Server 5.1.32 the ndb_cache_trans.test shows that queries being
part of a transaction is not always retrieved from the cache like they previously was.

This is caused by BUG#36326 that adds two additional bits in the hash key, containing the
servers status bits SERVER_STATUS_IN_TRANS and SERVER_STATUS_AUTOCOMMIT. This makes it
only possible to retrieve a query that was cached with exactly the same bits set.

How to repeat:
ndb_cache_trans in 6.2-merge

See also bug#42197