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 --error ER_NO_DEFAULT
11 set session rand_seed2=default;
12 set session rand_seed2=10969771;
13 select @@session.rand_seed2;
14 show global variables like 'rand_seed2';
15 show session variables like 'rand_seed2';
16 select * from information_schema.global_variables where variable_name='rand_seed2';
17 select * from information_schema.session_variables where variable_name='rand_seed2';
18
19 #
20 # show that it's writable (note value can be set but not read - returned value is zero)
21 #
22 set session rand_seed2=1;
23 select @@session.rand_seed2;
24 select * from information_schema.global_variables where variable_name='rand_seed2';
25 select * from information_schema.session_variables where variable_name='rand_seed2';
26 --error ER_LOCAL_VARIABLE
27 set global rand_seed2=1;
28
29 #
30 # incorrect types
31 #
32 --error ER_WRONG_TYPE_FOR_VAR
33 set session rand_seed2=1.1;
34 --error ER_WRONG_TYPE_FOR_VAR
35 set session rand_seed2=1e1;
36 --error ER_WRONG_TYPE_FOR_VAR
37 set session rand_seed2="foo";
38