Debian Codegraph @

mysql-test/suite/vcol/r/query_cache.result

raw
1 #
2 # MDEV-29186 Query cache makes virtual column function RAND() non-random
3 #
4 set global query_cache_type=1;
5 set query_cache_type=1;
6 set rand_seed1=1234567890, rand_seed2=20;
7 create table t1 (a int, b float as (rand()));
8 insert into t1 (a) values (1);
9 select * from t1;
10 a b
11 1 0.449343
12 select * from t1;
13 a b
14 1 0.797372
15 set global query_cache_type=default;
16 select * from t1;
17 a b
18 1 0.638829
19 drop table t1;
20 # End of 10.11 tests