Debian Codegraph @

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

raw
1 NO_LOG Expected
2 SELECT @@GLOBAL.binlog_row_metadata;
3 @@GLOBAL.binlog_row_metadata
4 NO_LOG
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 NO_LOG
18 NO_LOG Expected
19 SET @@GLOBAL.binlog_row_metadata=1;
20 SELECT @@GLOBAL.binlog_row_metadata;
21 @@GLOBAL.binlog_row_metadata
22 MINIMAL
23 MINIMAL Expected
24 SET @@GLOBAL.binlog_row_metadata=2;
25 SELECT @@GLOBAL.binlog_row_metadata;
26 @@GLOBAL.binlog_row_metadata
27 FULL
28 FULL Expected
29 SET @@GLOBAL.binlog_row_metadata=NO_LOG;
30 SELECT @@GLOBAL.binlog_row_metadata;
31 @@GLOBAL.binlog_row_metadata
32 NO_LOG
33 NO_LOG 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 SET @@GLOBAL.binlog_row_metadata='NO_LOG';
45 SELECT @@GLOBAL.binlog_row_metadata;
46 @@GLOBAL.binlog_row_metadata
47 NO_LOG
48 NO_LOG Expected
49 SET @@GLOBAL.binlog_row_metadata='MINIMAL';
50 SELECT @@GLOBAL.binlog_row_metadata;
51 @@GLOBAL.binlog_row_metadata
52 MINIMAL
53 MINIMAL Expected
54 SET @@GLOBAL.binlog_row_metadata='FULL';
55 SELECT @@GLOBAL.binlog_row_metadata;
56 @@GLOBAL.binlog_row_metadata
57 FULL
58 FULL Expected
59 '#---------------------BS_STVARS_002_03----------------------#'
60 SET @@GLOBAL.binlog_row_metadata='MINIMAl';
61 SELECT *
62 FROM information_schema.global_variables
63 WHERE VARIABLE_NAME='binlog_row_metadata';
64 VARIABLE_NAME VARIABLE_VALUE
65 BINLOG_ROW_METADATA MINIMAL
66 '#---------------------BS_STVARS_002_04----------------------#'
67 SELECT *
68 FROM information_schema.session_variables
69 WHERE VARIABLE_NAME LIKE 'binlog_row_metadata';
70 VARIABLE_NAME VARIABLE_VALUE
71 BINLOG_ROW_METADATA MINIMAL
72 '#---------------------BS_STVARS_002_05----------------------#'
73 SELECT COUNT(@@binlog_row_metadata);
74 COUNT(@@binlog_row_metadata)
75 1
76 1 Expected
77 SELECT COUNT(@@GLOBAL.binlog_row_metadata);
78 COUNT(@@GLOBAL.binlog_row_metadata)
79 1
80 1 Expected
81 '#---------------------BS_STVARS_002_06----------------------#'
82 SET GLOBAL binlog_row_metadata = full1;
83 ERROR 42000: Variable 'binlog_row_metadata' can't be set to the value of 'full1'
84 SET GLOBAL binlog_row_metadata = "full1";
85 ERROR 42000: Variable 'binlog_row_metadata' can't be set to the value of 'full1'
86 SET GLOBAL binlog_row_metadata = 3;
87 ERROR 42000: Variable 'binlog_row_metadata' can't be set to the value of '3'
88 SET GLOBAL binlog_row_metadata = -1;
89 ERROR 42000: Variable 'binlog_row_metadata' can't be set to the value of '-1'
90 SET @@global.binlog_row_metadata= @start_value;