← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.5/precise-201203300109

« back to all changes in this revision

Viewing changes to mysql-test/suite/sys_vars/r/relay_log_recovery_basic.result

  • Committer: Package Import Robot
  • Author(s): Clint Byrum
  • Date: 2011-11-08 11:31:13 UTC
  • Revision ID: package-import@ubuntu.com-20111108113113-3ulw01fvi4vn8m25
Tags: upstream-5.5.17
Import upstream version 5.5.17

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/sys_vars/r/relay_log_recovery_basic.result
 
1
SET @start_global_value = @@global.relay_log_recovery;
 
2
SELECT @start_global_value;
 
3
@start_global_value
 
4
0
 
5
select @@global.relay_log_recovery;
 
6
@@global.relay_log_recovery
 
7
0
 
8
select @@session.relay_log_recovery;
 
9
ERROR HY000: Variable 'relay_log_recovery' is a GLOBAL variable
 
10
show global variables like 'relay_log_recovery';
 
11
Variable_name   Value
 
12
relay_log_recovery      OFF
 
13
show session variables like 'relay_log_recovery';
 
14
Variable_name   Value
 
15
relay_log_recovery      OFF
 
16
select * from information_schema.global_variables where variable_name='relay_log_recovery';
 
17
VARIABLE_NAME   VARIABLE_VALUE
 
18
RELAY_LOG_RECOVERY      OFF
 
19
select * from information_schema.session_variables where variable_name='relay_log_recovery';
 
20
VARIABLE_NAME   VARIABLE_VALUE
 
21
RELAY_LOG_RECOVERY      OFF
 
22
set global relay_log_recovery=1;
 
23
select @@global.relay_log_recovery;
 
24
@@global.relay_log_recovery
 
25
1
 
26
select * from information_schema.global_variables where variable_name='relay_log_recovery';
 
27
VARIABLE_NAME   VARIABLE_VALUE
 
28
RELAY_LOG_RECOVERY      ON
 
29
select * from information_schema.session_variables where variable_name='relay_log_recovery';
 
30
VARIABLE_NAME   VARIABLE_VALUE
 
31
RELAY_LOG_RECOVERY      ON
 
32
set global relay_log_recovery=OFF;
 
33
select @@global.relay_log_recovery;
 
34
@@global.relay_log_recovery
 
35
0
 
36
select * from information_schema.global_variables where variable_name='relay_log_recovery';
 
37
VARIABLE_NAME   VARIABLE_VALUE
 
38
RELAY_LOG_RECOVERY      OFF
 
39
select * from information_schema.session_variables where variable_name='relay_log_recovery';
 
40
VARIABLE_NAME   VARIABLE_VALUE
 
41
RELAY_LOG_RECOVERY      OFF
 
42
set session relay_log_recovery=1;
 
43
ERROR HY000: Variable 'relay_log_recovery' is a GLOBAL variable and should be set with SET GLOBAL
 
44
set global relay_log_recovery=1.1;
 
45
ERROR 42000: Incorrect argument type to variable 'relay_log_recovery'
 
46
set global relay_log_recovery=1e1;
 
47
ERROR 42000: Incorrect argument type to variable 'relay_log_recovery'
 
48
set global relay_log_recovery="foo";
 
49
ERROR 42000: Variable 'relay_log_recovery' can't be set to the value of 'foo'
 
50
SET @@global.relay_log_recovery = @start_global_value;
 
51
SELECT @@global.relay_log_recovery;
 
52
@@global.relay_log_recovery
 
53
0