Queries using RANDOM_BYTES get stored in query cache

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;

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