Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: N/A
-
Fix Version/s: 10.10.1
-
Component/s: Query Cache, Server
-
Labels:None
Description
set @qcache= @@global.query_cache_type; |
set global query_cache_type= 1; |
set query_cache_type= 1; |
|
create table t1 (a int); |
insert into t1 values (1),(2); |
|
flush status;
|
select hex(random_bytes(a)) from t1; |
select * from information_schema.global_status where variable_name in ('Qcache_inserts','Qcache_hits'); |
select hex(random_bytes(a)) from t1; |
select * from information_schema.global_status where variable_name in ('Qcache_inserts','Qcache_hits'); |
|
# Cleanup
|
drop table t1; |
set global query_cache_type= @qcache; |
bb-10.10-MDEV-25704 1303dfde02 |
select hex(random_bytes(a)) from t1; |
hex(random_bytes(a))
|
10
|
A6EF
|
select * from information_schema.global_status where variable_name in ('Qcache_inserts','Qcache_hits'); |
VARIABLE_NAME VARIABLE_VALUE
|
QCACHE_HITS 0
|
QCACHE_INSERTS 1
|
select hex(random_bytes(a)) from t1; |
hex(random_bytes(a))
|
10
|
A6EF
|
select * from information_schema.global_status where variable_name in ('Qcache_inserts','Qcache_hits'); |
VARIABLE_NAME VARIABLE_VALUE
|
QCACHE_HITS 1
|
QCACHE_INSERTS 1
|
Attachments
Issue Links
- relates to
-
MDEV-25704 Add RANDOM_BYTES function
-
- Closed
-