Debian Codegraph @

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

raw
1 SELECT @@GLOBAL.binlog_row_metadata;
2 @@GLOBAL.binlog_row_metadata
3 MINIMAL
4 MINIMAL Expected
5 SELECT @@SESSION.binlog_row_metadata;
6 ERROR HY000: Variable 'binlog_row_metadata' is a GLOBAL variable
7 '#---------------------BS_STVARS_002_01----------------------#'
8 SET @start_value= @@global.binlog_row_metadata;
9 SELECT COUNT(@@GLOBAL.binlog_row_metadata);
10 COUNT(@@GLOBAL.binlog_row_metadata)
11 1
12 1 Expected
13 '#---------------------BS_STVARS_002_02----------------------#'
14 SET @@GLOBAL.binlog_row_metadata=0;
15 SELECT @@GLOBAL.binlog_row_metadata;
16 @@GLOBAL.binlog_row_metadata
17 MINIMAL
18 MINIMAL Expected
19 SET @@GLOBAL.binlog_row_metadata=1;
20 SELECT @@GLOBAL.binlog_row_metadata;
21 @@GLOBAL.binlog_row_metadata
22 FULL
23 FULL Expected
24 SET @@GLOBAL.binlog_row_metadata=MINIMAL;
25 SELECT @@GLOBAL.binlog_row_metadata;
26 @@GLOBAL.binlog_row_metadata
27 MINIMAL
28 MINIMAL Expected
29 SET @@GLOBAL.binlog_row_metadata=FULL;
30 SELECT @@GLOBAL.binlog_row_metadata;
31 @@GLOBAL.binlog_row_metadata
32 FULL
33 FULL Expected
34 SET @@GLOBAL.binlog_row_metadata='MINIMAL';
35 SELECT @@GLOBAL.binlog_row_metadata;
36 @@GLOBAL.binlog_row_metadata
37 MINIMAL
38 MINIMAL Expected
39 SET @@GLOBAL.binlog_row_metadata='FULL';
40 SELECT @@GLOBAL.binlog_row_metadata;
41 @@GLOBAL.binlog_row_metadata
42 FULL
43 FULL Expected
44 '#---------------------BS_STVARS_002_03----------------------#'
45 SELECT @@GLOBAL.binlog_row_metadata = VARIABLE_VALUE
46 FROM performance_schema.global_variables
47 WHERE VARIABLE_NAME='binlog_row_metadata';
48 @@GLOBAL.binlog_row_metadata = VARIABLE_VALUE
49 1
50 1 Expected
51 SELECT COUNT(@@GLOBAL.binlog_row_metadata);
52 COUNT(@@GLOBAL.binlog_row_metadata)
53 1
54 1 Expected
55 SELECT COUNT(VARIABLE_VALUE)
56 FROM performance_schema.global_variables
57 WHERE VARIABLE_NAME='binlog_row_metadata';
58 COUNT(VARIABLE_VALUE)
59 1
60 1 Expected
61 '#---------------------BS_STVARS_002_04----------------------#'
62 SELECT @@GLOBAL.binlog_row_metadata = VARIABLE_VALUE
63 FROM performance_schema.session_variables
64 WHERE VARIABLE_NAME LIKE 'binlog_row_metadata';
65 @@GLOBAL.binlog_row_metadata = VARIABLE_VALUE
66 1
67 '#---------------------BS_STVARS_002_05----------------------#'
68 SELECT COUNT(@@binlog_row_metadata);
69 COUNT(@@binlog_row_metadata)
70 1
71 1 Expected
72 SELECT COUNT(@@GLOBAL.binlog_row_metadata);
73 COUNT(@@GLOBAL.binlog_row_metadata)
74 1
75 1 Expected
76 '#---------------------BS_STVARS_002_06----------------------#'
77 SET GLOBAL binlog_row_metadata = full1;
78 ERROR 42000: Variable 'binlog_row_metadata' can't be set to the value of 'full1'
79 SET GLOBAL binlog_row_metadata = "full1";
80 ERROR 42000: Variable 'binlog_row_metadata' can't be set to the value of 'full1'
81 SET GLOBAL binlog_row_metadata = 2;
82 ERROR 42000: Variable 'binlog_row_metadata' can't be set to the value of '2'
83 SET GLOBAL binlog_row_metadata = -1;
84 ERROR 42000: Variable 'binlog_row_metadata' can't be set to the value of '-1'
85 SET @@global.binlog_row_metadata= @start_value;