Debian Codegraph @

mysql-test/suite/sys_vars/r/rand_seed2_basic.result

raw
1 select @@global.rand_seed2;
2 ERROR HY000: Variable 'rand_seed2' is a SESSION variable
3 set session rand_seed2=default;
4 ERROR 42000: Variable 'rand_seed2' doesn't have a default value
5 set session rand_seed2=10969771;
6 select @@session.rand_seed2;
7 @@session.rand_seed2
8 10969771
9 show global variables like 'rand_seed2';
10 Variable_name Value
11 show session variables like 'rand_seed2';
12 Variable_name Value
13 rand_seed2 10969771
14 select * from information_schema.global_variables where variable_name='rand_seed2';
15 VARIABLE_NAME VARIABLE_VALUE
16 select * from information_schema.session_variables where variable_name='rand_seed2';
17 VARIABLE_NAME VARIABLE_VALUE
18 RAND_SEED2 10969771
19 set session rand_seed2=1;
20 select @@session.rand_seed2;
21 @@session.rand_seed2
22 1
23 select * from information_schema.global_variables where variable_name='rand_seed2';
24 VARIABLE_NAME VARIABLE_VALUE
25 select * from information_schema.session_variables where variable_name='rand_seed2';
26 VARIABLE_NAME VARIABLE_VALUE
27 RAND_SEED2 1
28 set global rand_seed2=1;
29 ERROR HY000: Variable 'rand_seed2' is a SESSION variable and can't be used with SET GLOBAL
30 set session rand_seed2=1.1;
31 ERROR 42000: Incorrect argument type to variable 'rand_seed2'
32 set session rand_seed2=1e1;
33 ERROR 42000: Incorrect argument type to variable 'rand_seed2'
34 set session rand_seed2="foo";
35 ERROR 42000: Incorrect argument type to variable 'rand_seed2'