Debian Codegraph @

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

raw
1 SELECT @@GLOBAL.binlog_row_image;
2 @@GLOBAL.binlog_row_image
3 FULL
4 SELECT @@SESSION.binlog_row_image;
5 @@SESSION.binlog_row_image
6 FULL
7 FULL Expected
8 '#---------------------BS_STVARS_002_01----------------------#'
9 SET @start_value= @@global.binlog_row_image;
10 SELECT COUNT(@@GLOBAL.binlog_row_image);
11 COUNT(@@GLOBAL.binlog_row_image)
12 1
13 1 Expected
14 SELECT COUNT(@@SESSION.binlog_row_image);
15 COUNT(@@SESSION.binlog_row_image)
16 1
17 1 Expected
18 '#---------------------BS_STVARS_002_02----------------------#'
19 SET @@GLOBAL.binlog_row_image=0;
20 SELECT @@GLOBAL.binlog_row_image;
21 @@GLOBAL.binlog_row_image
22 MINIMAL
23 MINIMAL Expected
24 SET @@SESSION.binlog_row_image=0;
25 SELECT @@SESSION.binlog_row_image;
26 @@SESSION.binlog_row_image
27 MINIMAL
28 MINIMAL Expected
29 SET @@GLOBAL.binlog_row_image=1;
30 SELECT @@GLOBAL.binlog_row_image;
31 @@GLOBAL.binlog_row_image
32 NOBLOB
33 NOBLOB Expected
34 SET @@SESSION.binlog_row_image=1;
35 SELECT @@SESSION.binlog_row_image;
36 @@SESSION.binlog_row_image
37 NOBLOB
38 NOBLOB Expected
39 SET @@GLOBAL.binlog_row_image=2;
40 SELECT @@GLOBAL.binlog_row_image;
41 @@GLOBAL.binlog_row_image
42 FULL
43 FULL Expected
44 SET @@SESSION.binlog_row_image=2;
45 SELECT @@SESSION.binlog_row_image;
46 @@SESSION.binlog_row_image
47 FULL
48 FULL Expected
49 '#---------------------BS_STVARS_002_03----------------------#'
50 SELECT @@GLOBAL.binlog_row_image = VARIABLE_VALUE
51 FROM performance_schema.global_variables
52 WHERE VARIABLE_NAME='binlog_row_image';
53 @@GLOBAL.binlog_row_image = VARIABLE_VALUE
54 1
55 1 Expected
56 SELECT COUNT(@@GLOBAL.binlog_row_image);
57 COUNT(@@GLOBAL.binlog_row_image)
58 1
59 1 Expected
60 SELECT COUNT(VARIABLE_VALUE)
61 FROM performance_schema.global_variables
62 WHERE VARIABLE_NAME='binlog_row_image';
63 COUNT(VARIABLE_VALUE)
64 1
65 1 Expected
66 '#---------------------BS_STVARS_002_04----------------------#'
67 SELECT @@SESSION.binlog_row_image = VARIABLE_VALUE
68 FROM performance_schema.session_variables
69 WHERE VARIABLE_NAME='binlog_row_image';
70 @@SESSION.binlog_row_image = VARIABLE_VALUE
71 1
72 1 Expected
73 SELECT COUNT(@@SESSION.binlog_row_image);
74 COUNT(@@SESSION.binlog_row_image)
75 1
76 1 Expected
77 SELECT COUNT(VARIABLE_VALUE)
78 FROM performance_schema.session_variables
79 WHERE VARIABLE_NAME='binlog_row_image';
80 COUNT(VARIABLE_VALUE)
81 1
82 1 Expected
83 '#---------------------BS_STVARS_002_05----------------------#'
84 SELECT COUNT(@@binlog_row_image);
85 COUNT(@@binlog_row_image)
86 1
87 1 Expected
88 SELECT COUNT(@@local.binlog_row_image);
89 COUNT(@@local.binlog_row_image)
90 1
91 1 Expected
92 SELECT COUNT(@@SESSION.binlog_row_image);
93 COUNT(@@SESSION.binlog_row_image)
94 1
95 1 Expected
96 SELECT COUNT(@@GLOBAL.binlog_row_image);
97 COUNT(@@GLOBAL.binlog_row_image)
98 1
99 1 Expected
100 SET @@global.binlog_row_image= @start_value;