Debian Codegraph @

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

raw
1 SELECT @@GLOBAL.binlog_direct_non_transactional_updates;
2 @@GLOBAL.binlog_direct_non_transactional_updates
3 0
4 '#---------------------BS_STVARS_002_01----------------------#'
5 SET @start_value= @@global.binlog_direct_non_transactional_updates;
6 SELECT COUNT(@@GLOBAL.binlog_direct_non_transactional_updates);
7 COUNT(@@GLOBAL.binlog_direct_non_transactional_updates)
8 1
9 1 Expected
10 SELECT COUNT(@@SESSION.binlog_direct_non_transactional_updates);
11 COUNT(@@SESSION.binlog_direct_non_transactional_updates)
12 1
13 1 Expected
14 '#---------------------BS_STVARS_002_02----------------------#'
15 SET @@GLOBAL.binlog_direct_non_transactional_updates=TRUE;
16 SELECT @@GLOBAL.binlog_direct_non_transactional_updates;
17 @@GLOBAL.binlog_direct_non_transactional_updates
18 1
19 SET @@SESSION.binlog_direct_non_transactional_updates=TRUE;
20 SELECT @@SESSION.binlog_direct_non_transactional_updates;
21 @@SESSION.binlog_direct_non_transactional_updates
22 1
23 '#---------------------BS_STVARS_002_03----------------------#'
24 SELECT
25 IF(@@GLOBAL.binlog_direct_non_transactional_updates, "ON", "OFF") = VARIABLE_VALUE
26 FROM performance_schema.global_variables
27 WHERE VARIABLE_NAME='binlog_direct_non_transactional_updates';
28 IF(@@GLOBAL.binlog_direct_non_transactional_updates, "ON", "OFF") = VARIABLE_VALUE
29 1
30 1 Expected
31 SELECT COUNT(@@GLOBAL.binlog_direct_non_transactional_updates);
32 COUNT(@@GLOBAL.binlog_direct_non_transactional_updates)
33 1
34 1 Expected
35 SELECT COUNT(VARIABLE_VALUE)
36 FROM performance_schema.global_variables
37 WHERE VARIABLE_NAME='binlog_direct_non_transactional_updates';
38 COUNT(VARIABLE_VALUE)
39 1
40 1 Expected
41 '#---------------------BS_STVARS_002_04----------------------#'
42 SELECT
43 IF(@@SESSION.binlog_direct_non_transactional_updates, "ON", "OFF") = VARIABLE_VALUE
44 FROM performance_schema.session_variables
45 WHERE VARIABLE_NAME='binlog_direct_non_transactional_updates';
46 IF(@@SESSION.binlog_direct_non_transactional_updates, "ON", "OFF") = VARIABLE_VALUE
47 1
48 1 Expected
49 SELECT COUNT(@@SESSION.binlog_direct_non_transactional_updates);
50 COUNT(@@SESSION.binlog_direct_non_transactional_updates)
51 1
52 1 Expected
53 SELECT COUNT(VARIABLE_VALUE)
54 FROM performance_schema.session_variables
55 WHERE VARIABLE_NAME='binlog_direct_non_transactional_updates';
56 COUNT(VARIABLE_VALUE)
57 1
58 1 Expected
59 '#---------------------BS_STVARS_002_05----------------------#'
60 SELECT COUNT(@@binlog_direct_non_transactional_updates);
61 COUNT(@@binlog_direct_non_transactional_updates)
62 1
63 1 Expected
64 SELECT COUNT(@@local.binlog_direct_non_transactional_updates);
65 COUNT(@@local.binlog_direct_non_transactional_updates)
66 1
67 1 Expected
68 SELECT COUNT(@@SESSION.binlog_direct_non_transactional_updates);
69 COUNT(@@SESSION.binlog_direct_non_transactional_updates)
70 1
71 1 Expected
72 SELECT COUNT(@@GLOBAL.binlog_direct_non_transactional_updates);
73 COUNT(@@GLOBAL.binlog_direct_non_transactional_updates)
74 1
75 1 Expected
76 SET @@global.binlog_direct_non_transactional_updates= @start_value;