Debian Codegraph @

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

raw
1 '#---------------------BS_STVARS_002_01----------------------#'
2 SET @start_value= @@global.log_bin_use_v1_row_events;
3 Warnings:
4 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
5 SELECT @start_value;
6 @start_value
7 0
8 SELECT COUNT(@@GLOBAL.log_bin_use_v1_row_events);
9 COUNT(@@GLOBAL.log_bin_use_v1_row_events)
10 1
11 Warnings:
12 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
13 1 Expected
14 '#---------------------BS_STVARS_002_02----------------------#'
15 SET @@global.log_bin_use_v1_row_events = TRUE;
16 Warnings:
17 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
18 SET @@global.log_bin_use_v1_row_events = DEFAULT;
19 Warnings:
20 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
21 SELECT @@global.log_bin_use_v1_row_events;
22 @@global.log_bin_use_v1_row_events
23 0
24 Warnings:
25 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
26 SET @@global.log_bin_use_v1_row_events = ON;
27 Warnings:
28 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
29 SELECT @@global.log_bin_use_v1_row_events;
30 @@global.log_bin_use_v1_row_events
31 1
32 Warnings:
33 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
34 SET @@global.log_bin_use_v1_row_events = OFF;
35 Warnings:
36 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
37 SELECT @@global.log_bin_use_v1_row_events;
38 @@global.log_bin_use_v1_row_events
39 0
40 Warnings:
41 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
42 SET @@global.log_bin_use_v1_row_events = 1;
43 Warnings:
44 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
45 SELECT @@global.log_bin_use_v1_row_events;
46 @@global.log_bin_use_v1_row_events
47 1
48 Warnings:
49 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
50 SET @@global.log_bin_use_v1_row_events = 0;
51 Warnings:
52 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
53 SELECT @@global.log_bin_use_v1_row_events;
54 @@global.log_bin_use_v1_row_events
55 0
56 Warnings:
57 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
58 SET @@global.log_bin_use_v1_row_events = TRUE;
59 Warnings:
60 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
61 SELECT @@global.log_bin_use_v1_row_events;
62 @@global.log_bin_use_v1_row_events
63 1
64 Warnings:
65 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
66 SET @@global.log_bin_use_v1_row_events = FALSE;
67 Warnings:
68 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
69 SELECT @@global.log_bin_use_v1_row_events;
70 @@global.log_bin_use_v1_row_events
71 0
72 Warnings:
73 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
74 '#-------------------FN_DYNVARS_063_04----------------------------#'
75 SET @@session.log_bin_use_v1_row_events = 0;
76 ERROR HY000: Variable 'log_bin_use_v1_row_events' is a GLOBAL variable and should be set with SET GLOBAL
77 SELECT @@session.log_bin_use_v1_row_events;
78 ERROR HY000: Variable 'log_bin_use_v1_row_events' is a GLOBAL variable
79 '#---------------------BS_STVARS_002_03----------------------#'
80 SELECT IF(@@GLOBAL.log_bin_use_v1_row_events, "ON", "OFF") = VARIABLE_VALUE
81 FROM performance_schema.global_variables
82 WHERE VARIABLE_NAME='log_bin_use_v1_row_events';
83 IF(@@GLOBAL.log_bin_use_v1_row_events, "ON", "OFF") = VARIABLE_VALUE
84 1
85 1 Expected
86 SELECT COUNT(@@GLOBAL.log_bin_use_v1_row_events);
87 COUNT(@@GLOBAL.log_bin_use_v1_row_events)
88 1
89 Warnings:
90 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
91 1 Expected
92 SELECT COUNT(VARIABLE_VALUE)
93 FROM performance_schema.global_variables
94 WHERE VARIABLE_NAME='log_bin_use_v1_row_events';
95 COUNT(VARIABLE_VALUE)
96 1
97 1 Expected
98 '#---------------------BS_STVARS_002_05----------------------#'
99 SELECT COUNT(@@log_bin_use_v1_row_events);
100 COUNT(@@log_bin_use_v1_row_events)
101 1
102 Warnings:
103 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
104 1 Expected
105 SELECT COUNT(@@GLOBAL.log_bin_use_v1_row_events);
106 COUNT(@@GLOBAL.log_bin_use_v1_row_events)
107 1
108 Warnings:
109 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
110 1 Expected
111 SET @@global.log_bin_use_v1_row_events= @start_value;
112 Warnings:
113 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.