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 |