Debian Codegraph @

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

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