diff options
Diffstat (limited to 'mysql-test/main/query_cache.result')
| -rw-r--r-- | mysql-test/main/query_cache.result | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/main/query_cache.result b/mysql-test/main/query_cache.result index 3a81b648171..f78a6ccc388 100644 --- a/mysql-test/main/query_cache.result +++ b/mysql-test/main/query_cache.result @@ -2239,3 +2239,28 @@ DROP TABLE t; restore defaults SET GLOBAL query_cache_type= default; SET GLOBAL query_cache_size=@save_query_cache_size; +# +# MDEV-29028: 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 (1000); +flush status; +select * from information_schema.global_status where variable_name in ('Qcache_inserts','Qcache_hits') order by variable_name; +VARIABLE_NAME VARIABLE_VALUE +QCACHE_HITS 0 +QCACHE_INSERTS 0 +select * from information_schema.global_status where variable_name in ('Qcache_inserts','Qcache_hits') order by variable_name; +VARIABLE_NAME VARIABLE_VALUE +QCACHE_HITS 0 +QCACHE_INSERTS 0 +select random_bytes(1024) = random_bytes(1024) as improbable; +improbable +0 +drop table t1; +set global query_cache_type= @qcache; +# +# End of 10.10 tests +# |