Debian Codegraph @

mysql-test/suite/sys_vars/t/rand_seed1_basic.test

raw
1
2 #
3 # exists as a session only
4 #
5 # 2010-01-20 OBN - Added check for I_S value after variable value change
6 #
7 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
8 select @@global.rand_seed1;
9 select @@session.rand_seed1;
10 show global variables like 'rand_seed1';
11 show session variables like 'rand_seed1';
12 --disable_warnings
13 select * from performance_schema.global_variables where variable_name='rand_seed1';
14 select * from performance_schema.session_variables where variable_name='rand_seed1';
15 --enable_warnings
16
17 #
18 # show that it's writable (note value can be set but not read - returned value is zero)
19 #
20 set session rand_seed1=1;
21 select @@session.rand_seed1;
22 --disable_warnings
23 select * from performance_schema.global_variables where variable_name='rand_seed1';
24 select * from performance_schema.session_variables where variable_name='rand_seed1';
25 --enable_warnings
26 --error ER_LOCAL_VARIABLE
27 set global rand_seed1=1;
28
29 #
30 # incorrect types
31 #
32 --error ER_WRONG_TYPE_FOR_VAR
33 set session rand_seed1=1.1;
34 --error ER_WRONG_TYPE_FOR_VAR
35 set session rand_seed1=1e1;
36 --error ER_WRONG_TYPE_FOR_VAR
37 set session rand_seed1="foo";
38