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