diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/rand_seed1_basic.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/rand_seed1_basic.result | 13 |
1 files changed, 8 insertions, 5 deletions
diff --git a/mysql-test/suite/sys_vars/r/rand_seed1_basic.result b/mysql-test/suite/sys_vars/r/rand_seed1_basic.result index 155d7169168..c4244dabcbe 100644 --- a/mysql-test/suite/sys_vars/r/rand_seed1_basic.result +++ b/mysql-test/suite/sys_vars/r/rand_seed1_basic.result @@ -1,27 +1,30 @@ select @@global.rand_seed1; ERROR HY000: Variable 'rand_seed1' is a SESSION variable +set session rand_seed1=default; +ERROR 42000: Variable 'rand_seed1' doesn't have a default value +set session rand_seed1=10969771; select @@session.rand_seed1; @@session.rand_seed1 -0 +10969771 show global variables like 'rand_seed1'; Variable_name Value show session variables like 'rand_seed1'; Variable_name Value -rand_seed1 0 +rand_seed1 10969771 select * from information_schema.global_variables where variable_name='rand_seed1'; VARIABLE_NAME VARIABLE_VALUE select * from information_schema.session_variables where variable_name='rand_seed1'; VARIABLE_NAME VARIABLE_VALUE -RAND_SEED1 0 +RAND_SEED1 10969771 set session rand_seed1=1; select @@session.rand_seed1; @@session.rand_seed1 -0 +1 select * from information_schema.global_variables where variable_name='rand_seed1'; VARIABLE_NAME VARIABLE_VALUE select * from information_schema.session_variables where variable_name='rand_seed1'; VARIABLE_NAME VARIABLE_VALUE -RAND_SEED1 0 +RAND_SEED1 1 set global rand_seed1=1; ERROR HY000: Variable 'rand_seed1' is a SESSION variable and can't be used with SET GLOBAL set session rand_seed1=1.1; |