Debian Codegraph @

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

raw
1 SELECT @@GLOBAL.binlog_format;
2 @@GLOBAL.binlog_format
3 #
4 Warnings:
5 # 1287 '@@binlog_format' is deprecated and will be removed in a future release.
6 '#---------------------BS_STVARS_002_01----------------------#'
7 SET @start_value= @@global.binlog_format;
8 Warnings:
9 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
10 SELECT COUNT(@@GLOBAL.binlog_format);
11 COUNT(@@GLOBAL.binlog_format)
12 1
13 Warnings:
14 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
15 1 Expected
16 SELECT COUNT(@@SESSION.binlog_format);
17 COUNT(@@SESSION.binlog_format)
18 1
19 Warnings:
20 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
21 1 Expected
22 '#---------------------BS_STVARS_002_02----------------------#'
23 SET @@GLOBAL.binlog_format=1;
24 Warnings:
25 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
26 SELECT @@GLOBAL.binlog_format;
27 @@GLOBAL.binlog_format
28 STATEMENT
29 Warnings:
30 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
31 SET @@SESSION.binlog_format=1;
32 Warnings:
33 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
34 SELECT @@SESSION.binlog_format;
35 @@SESSION.binlog_format
36 STATEMENT
37 Warnings:
38 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
39 '#---------------------BS_STVARS_002_03----------------------#'
40 SELECT @@GLOBAL.binlog_format = VARIABLE_VALUE
41 FROM performance_schema.global_variables
42 WHERE VARIABLE_NAME='binlog_format';
43 @@GLOBAL.binlog_format = VARIABLE_VALUE
44 1
45 1 Expected
46 SELECT COUNT(@@GLOBAL.binlog_format);
47 COUNT(@@GLOBAL.binlog_format)
48 1
49 Warnings:
50 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
51 1 Expected
52 SELECT COUNT(VARIABLE_VALUE)
53 FROM performance_schema.global_variables
54 WHERE VARIABLE_NAME='binlog_format';
55 COUNT(VARIABLE_VALUE)
56 1
57 1 Expected
58 '#---------------------BS_STVARS_002_04----------------------#'
59 SELECT @@SESSION.binlog_format = VARIABLE_VALUE
60 FROM performance_schema.session_variables
61 WHERE VARIABLE_NAME='binlog_format';
62 @@SESSION.binlog_format = VARIABLE_VALUE
63 1
64 1 Expected
65 SELECT COUNT(@@SESSION.binlog_format);
66 COUNT(@@SESSION.binlog_format)
67 1
68 Warnings:
69 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
70 1 Expected
71 SELECT COUNT(VARIABLE_VALUE)
72 FROM performance_schema.session_variables
73 WHERE VARIABLE_NAME='binlog_format';
74 COUNT(VARIABLE_VALUE)
75 1
76 1 Expected
77 '#---------------------BS_STVARS_002_05----------------------#'
78 SELECT COUNT(@@binlog_format);
79 COUNT(@@binlog_format)
80 1
81 Warnings:
82 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
83 1 Expected
84 SELECT COUNT(@@local.binlog_format);
85 COUNT(@@local.binlog_format)
86 1
87 Warnings:
88 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
89 1 Expected
90 SELECT COUNT(@@SESSION.binlog_format);
91 COUNT(@@SESSION.binlog_format)
92 1
93 Warnings:
94 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
95 1 Expected
96 SELECT COUNT(@@GLOBAL.binlog_format);
97 COUNT(@@GLOBAL.binlog_format)
98 1
99 Warnings:
100 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
101 1 Expected
102 #########################################################################
103 # Bug #26269280: SET SESSION BINLOG_FORMAT = ROW GIVES SYNTAX ERROR #
104 #########################################################################
105 SET binlog_format = ROW;
106 Warnings:
107 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
108 SET SESSION binlog_format = ROW;
109 Warnings:
110 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
111 SET @@session.binlog_format= ROW;
112 Warnings:
113 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
114 #########################################################################
115 SET @@global.binlog_format= @start_value;
116 Warnings:
117 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.