← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-02-12 11:54:27 UTC
  • Revision ID: package-import@ubuntu.com-20140212115427-oq6tfsqxl1wuwehi
Tags: upstream-5.6.15
Import upstream version 5.6.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/sys_vars/r/relay_log_info_repository_basic.result
 
1
CALL mtr.add_suppression("The repository is not configured properly. Please, fix this before using replication.");
 
2
'#---------------------BS_STVARS_002_01----------------------#'
 
3
SELECT @@GLOBAL.relay_log_info_repository;
 
4
@@GLOBAL.relay_log_info_repository
 
5
FILE
 
6
SELECT COUNT(@@GLOBAL.relay_log_info_repository);
 
7
COUNT(@@GLOBAL.relay_log_info_repository)
 
8
1
 
9
1 Expected
 
10
SELECT COUNT(@@SESSION.relay_log_info_repository);
 
11
ERROR HY000: Variable 'relay_log_info_repository' is a GLOBAL variable
 
12
'#---------------------BS_STVARS_002_02----------------------#'
 
13
SET @@GLOBAL.relay_log_info_repository= "TABLE";
 
14
SELECT @@GLOBAL.relay_log_info_repository;
 
15
@@GLOBAL.relay_log_info_repository
 
16
TABLE
 
17
'#---------------------BS_STVARS_002_03----------------------#'
 
18
SELECT @@GLOBAL.relay_log_info_repository = VARIABLE_VALUE
 
19
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
 
20
WHERE VARIABLE_NAME='relay_log_info_repository';
 
21
@@GLOBAL.relay_log_info_repository = VARIABLE_VALUE
 
22
1
 
23
1 Expected
 
24
SELECT COUNT(@@GLOBAL.relay_log_info_repository);
 
25
COUNT(@@GLOBAL.relay_log_info_repository)
 
26
1
 
27
1 Expected
 
28
SELECT COUNT(VARIABLE_VALUE)
 
29
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
 
30
WHERE VARIABLE_NAME='relay_log_info_repository';
 
31
COUNT(VARIABLE_VALUE)
 
32
1
 
33
1 Expected
 
34
'#---------------------BS_STVARS_002_05----------------------#'
 
35
SELECT COUNT(@@relay_log_info_repository);
 
36
COUNT(@@relay_log_info_repository)
 
37
1
 
38
1 Expected
 
39
SELECT COUNT(@@local.relay_log_info_repository);
 
40
ERROR HY000: Variable 'relay_log_info_repository' is a GLOBAL variable
 
41
SELECT COUNT(@@GLOBAL.relay_log_info_repository);
 
42
COUNT(@@GLOBAL.relay_log_info_repository)
 
43
1
 
44
1 Expected
 
45
'#---------------------BS_STVARS_002_06----------------------#'
 
46
SET @@GLOBAL.relay_log_info_repository= "FILE";