Debian Codegraph @

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

raw
1 SET @start_value = @@global.binlog_order_commits;
2 SELECT @start_value;
3 @start_value
4 1
5 '#---------------------FN_DYNVARS_004_01-------------------------#'
6 SET @@global.binlog_order_commits = DEFAULT;
7 SELECT @@global.binlog_order_commits = FALSE;
8 @@global.binlog_order_commits = FALSE
9 0
10 '#--------------------FN_DYNVARS_004_02------------------------#'
11 SET @@global.binlog_order_commits = ON;
12 SELECT @@global.binlog_order_commits;
13 @@global.binlog_order_commits
14 1
15 SET @@global.binlog_order_commits = OFF;
16 SELECT @@global.binlog_order_commits;
17 @@global.binlog_order_commits
18 0
19 '#--------------------FN_DYNVARS_004_03-------------------------#'
20 SET @@global.binlog_order_commits = 2;
21 ERROR 42000: Variable 'binlog_order_commits' can't be set to the value of '2'
22 SET @@global.binlog_order_commits = -1;
23 ERROR 42000: Variable 'binlog_order_commits' can't be set to the value of '-1'
24 SET @@global.binlog_order_commits = TRUEF;
25 ERROR 42000: Variable 'binlog_order_commits' can't be set to the value of 'TRUEF'
26 SET @@global.binlog_order_commits = TRUE_F;
27 ERROR 42000: Variable 'binlog_order_commits' can't be set to the value of 'TRUE_F'
28 SET @@global.binlog_order_commits = FALSE0;
29 ERROR 42000: Variable 'binlog_order_commits' can't be set to the value of 'FALSE0'
30 SET @@global.binlog_order_commits = OON;
31 ERROR 42000: Variable 'binlog_order_commits' can't be set to the value of 'OON'
32 SET @@global.binlog_order_commits = ONN;
33 ERROR 42000: Variable 'binlog_order_commits' can't be set to the value of 'ONN'
34 SET @@global.binlog_order_commits = OOFF;
35 ERROR 42000: Variable 'binlog_order_commits' can't be set to the value of 'OOFF'
36 SET @@global.binlog_order_commits = 0FF;
37 ERROR 42000: Variable 'binlog_order_commits' can't be set to the value of '0FF'
38 SET @@global.binlog_order_commits = ' ';
39 ERROR 42000: Variable 'binlog_order_commits' can't be set to the value of ' '
40 SET @@global.binlog_order_commits = " ";
41 ERROR 42000: Variable 'binlog_order_commits' can't be set to the value of ' '
42 SET @@global.binlog_order_commits = '';
43 ERROR 42000: Variable 'binlog_order_commits' can't be set to the value of ''
44 '#-------------------FN_DYNVARS_004_04----------------------------#'
45 SET @@session.binlog_order_commits = OFF;
46 ERROR HY000: Variable 'binlog_order_commits' is a GLOBAL variable and should be set with SET GLOBAL
47 SELECT @@session.binlog_order_commits;
48 ERROR HY000: Variable 'binlog_order_commits' is a GLOBAL variable
49 '#----------------------FN_DYNVARS_004_05------------------------#'
50 SELECT IF(@@global.binlog_order_commits, "ON", "OFF") = VARIABLE_VALUE
51 FROM performance_schema.global_variables
52 WHERE VARIABLE_NAME='binlog_order_commits';
53 IF(@@global.binlog_order_commits, "ON", "OFF") = VARIABLE_VALUE
54 1
55 '#---------------------FN_DYNVARS_004_06----------------------#'
56 SET @@global.binlog_order_commits = 0;
57 SELECT @@global.binlog_order_commits;
58 @@global.binlog_order_commits
59 0
60 SET @@global.binlog_order_commits = 1;
61 SELECT @@global.binlog_order_commits;
62 @@global.binlog_order_commits
63 1
64 '#---------------------FN_DYNVARS_004_07----------------------#'
65 SET @@global.binlog_order_commits = TRUE;
66 SELECT @@global.binlog_order_commits;
67 @@global.binlog_order_commits
68 1
69 SET @@global.binlog_order_commits = FALSE;
70 SELECT @@global.binlog_order_commits;
71 @@global.binlog_order_commits
72 0
73 '#---------------------FN_DYNVARS_004_08----------------------#'
74 SET @@global.binlog_order_commits = ON;
75 SELECT @@binlog_order_commits = @@global.binlog_order_commits;
76 @@binlog_order_commits = @@global.binlog_order_commits
77 1
78 '#---------------------FN_DYNVARS_004_09----------------------#'
79 SET binlog_order_commits = ON;
80 ERROR HY000: Variable 'binlog_order_commits' is a GLOBAL variable and should be set with SET GLOBAL
81 SET local.binlog_order_commits = OFF;
82 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.binlog_order_commits = OFF' at line 1
83 SELECT local.binlog_order_commits;
84 ERROR 42S02: Unknown table 'local' in field list
85 SET global.binlog_order_commits = ON;
86 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.binlog_order_commits = ON' at line 1
87 SELECT global.binlog_order_commits;
88 ERROR 42S02: Unknown table 'global' in field list
89 SELECT binlog_order_commits;
90 ERROR 42S22: Unknown column 'binlog_order_commits' in 'field list'
91 SELECT @@session.binlog_order_commits;
92 ERROR HY000: Variable 'binlog_order_commits' is a GLOBAL variable
93 SET @@global.binlog_order_commits = @start_value;
94 SELECT @@global.binlog_order_commits;
95 @@global.binlog_order_commits
96 1