mirror of
https://github.com/MariaDB/server.git
synced 2025-07-16 16:28:15 +02:00
20 lines
423 B
Text
20 lines
423 B
Text
#
|
|
# MDEV-29186 Query cache makes virtual column function RAND() non-random
|
|
#
|
|
set global query_cache_type=1;
|
|
set query_cache_type=1;
|
|
set rand_seed1=1234567890, rand_seed2=20;
|
|
create table t1 (a int, b float as (rand()));
|
|
insert into t1 (a) values (1);
|
|
select * from t1;
|
|
a b
|
|
1 0.449343
|
|
select * from t1;
|
|
a b
|
|
1 0.797372
|
|
set global query_cache_type=default;
|
|
select * from t1;
|
|
a b
|
|
1 0.638829
|
|
drop table t1;
|
|
# End of 10.11 tests
|