Debian Codegraph @

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

raw
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.master_info_repository;
4 @@GLOBAL.master_info_repository
5 TABLE
6 Warnings:
7 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
8 SELECT COUNT(@@GLOBAL.master_info_repository);
9 COUNT(@@GLOBAL.master_info_repository)
10 1
11 Warnings:
12 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
13 1 Expected
14 SELECT COUNT(@@SESSION.master_info_repository);
15 ERROR HY000: Variable 'master_info_repository' is a GLOBAL variable
16 '#---------------------BS_STVARS_002_02----------------------#'
17 SET @@GLOBAL.master_info_repository= "FILE";
18 Warnings:
19 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
20 SELECT @@GLOBAL.master_info_repository;
21 @@GLOBAL.master_info_repository
22 FILE
23 Warnings:
24 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
25 '#---------------------BS_STVARS_002_03----------------------#'
26 SELECT @@GLOBAL.master_info_repository = VARIABLE_VALUE
27 FROM performance_schema.global_variables
28 WHERE VARIABLE_NAME='master_info_repository';
29 @@GLOBAL.master_info_repository = VARIABLE_VALUE
30 1
31 1 Expected
32 SELECT COUNT(@@GLOBAL.master_info_repository);
33 COUNT(@@GLOBAL.master_info_repository)
34 1
35 Warnings:
36 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
37 1 Expected
38 SELECT COUNT(VARIABLE_VALUE)
39 FROM performance_schema.global_variables
40 WHERE VARIABLE_NAME='master_info_repository';
41 COUNT(VARIABLE_VALUE)
42 1
43 1 Expected
44 '#---------------------BS_STVARS_002_05----------------------#'
45 SELECT COUNT(@@master_info_repository);
46 COUNT(@@master_info_repository)
47 1
48 Warnings:
49 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
50 1 Expected
51 SELECT COUNT(@@local.master_info_repository);
52 ERROR HY000: Variable 'master_info_repository' is a GLOBAL variable
53 SELECT COUNT(@@GLOBAL.master_info_repository);
54 COUNT(@@GLOBAL.master_info_repository)
55 1
56 Warnings:
57 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
58 1 Expected
59 '#---------------------BS_STVARS_002_06----------------------#'
60 SET @@GLOBAL.master_info_repository= "TABLE";
61 Warnings:
62 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.