Debian Codegraph @

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

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