Debian Codegraph @

mysql-test/suite/vcol/t/query_cache.test

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