Debian Codegraph @

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

raw
1 SELECT @@GLOBAL.binlog_format;
2 @@GLOBAL.binlog_format
3 MIXED
4 '#---------------------BS_STVARS_002_01----------------------#'
5 SET @start_value= @@global.binlog_format;
6 SELECT COUNT(@@GLOBAL.binlog_format);
7 COUNT(@@GLOBAL.binlog_format)
8 1
9 1 Expected
10 SELECT COUNT(@@SESSION.binlog_format);
11 COUNT(@@SESSION.binlog_format)
12 1
13 1 Expected
14 '#---------------------BS_STVARS_002_02----------------------#'
15 SET @@GLOBAL.binlog_format=1;
16 SELECT @@GLOBAL.binlog_format;
17 @@GLOBAL.binlog_format
18 STATEMENT
19 SET @@SESSION.binlog_format=1;
20 SELECT @@SESSION.binlog_format;
21 @@SESSION.binlog_format
22 STATEMENT
23 '#---------------------BS_STVARS_002_03----------------------#'
24 SELECT @@GLOBAL.binlog_format = VARIABLE_VALUE
25 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
26 WHERE VARIABLE_NAME='binlog_format';
27 @@GLOBAL.binlog_format = VARIABLE_VALUE
28 1
29 1 Expected
30 SELECT COUNT(@@GLOBAL.binlog_format);
31 COUNT(@@GLOBAL.binlog_format)
32 1
33 1 Expected
34 SELECT COUNT(VARIABLE_VALUE)
35 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
36 WHERE VARIABLE_NAME='binlog_format';
37 COUNT(VARIABLE_VALUE)
38 1
39 1 Expected
40 '#---------------------BS_STVARS_002_04----------------------#'
41 SELECT @@SESSION.binlog_format = VARIABLE_VALUE
42 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
43 WHERE VARIABLE_NAME='binlog_format';
44 @@SESSION.binlog_format = VARIABLE_VALUE
45 1
46 1 Expected
47 SELECT COUNT(@@SESSION.binlog_format);
48 COUNT(@@SESSION.binlog_format)
49 1
50 1 Expected
51 SELECT COUNT(VARIABLE_VALUE)
52 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
53 WHERE VARIABLE_NAME='binlog_format';
54 COUNT(VARIABLE_VALUE)
55 1
56 1 Expected
57 '#---------------------BS_STVARS_002_05----------------------#'
58 SELECT COUNT(@@binlog_format);
59 COUNT(@@binlog_format)
60 1
61 1 Expected
62 SELECT COUNT(@@local.binlog_format);
63 COUNT(@@local.binlog_format)
64 1
65 1 Expected
66 SELECT COUNT(@@SESSION.binlog_format);
67 COUNT(@@SESSION.binlog_format)
68 1
69 1 Expected
70 SELECT COUNT(@@GLOBAL.binlog_format);
71 COUNT(@@GLOBAL.binlog_format)
72 1
73 1 Expected
74 SET @@global.binlog_format= @start_value;