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 select @@session.rand_seed2;
4 @@session.rand_seed2
5 0
6 show global variables like 'rand_seed2';
7 Variable_name Value
8 show session variables like 'rand_seed2';
9 Variable_name Value
10 rand_seed2 0
11 select * from performance_schema.global_variables where variable_name='rand_seed2';
12 VARIABLE_NAME VARIABLE_VALUE
13 select * from performance_schema.session_variables where variable_name='rand_seed2';
14 VARIABLE_NAME VARIABLE_VALUE
15 rand_seed2 0
16 set session rand_seed2=1;
17 select @@session.rand_seed2;
18 @@session.rand_seed2
19 0
20 select * from performance_schema.global_variables where variable_name='rand_seed2';
21 VARIABLE_NAME VARIABLE_VALUE
22 select * from performance_schema.session_variables where variable_name='rand_seed2';
23 VARIABLE_NAME VARIABLE_VALUE
24 rand_seed2 0
25 set global rand_seed2=1;
26 ERROR HY000: Variable 'rand_seed2' is a SESSION variable and can't be used with SET GLOBAL
27 set session rand_seed2=1.1;
28 ERROR 42000: Incorrect argument type to variable 'rand_seed2'
29 set session rand_seed2=1e1;
30 ERROR 42000: Incorrect argument type to variable 'rand_seed2'
31 set session rand_seed2="foo";
32 ERROR 42000: Incorrect argument type to variable 'rand_seed2'