1SELECT @@GLOBAL.binlog_direct_non_transactional_updates;
2@@GLOBAL.binlog_direct_non_transactional_updates
31
4'#---------------------BS_STVARS_002_01----------------------#'
5SET @start_value= @@global.binlog_direct_non_transactional_updates;
6SELECT COUNT(@@GLOBAL.binlog_direct_non_transactional_updates);
7COUNT(@@GLOBAL.binlog_direct_non_transactional_updates)
81
91 Expected
10SELECT COUNT(@@SESSION.binlog_direct_non_transactional_updates);
11COUNT(@@SESSION.binlog_direct_non_transactional_updates)
121
131 Expected
14'#---------------------BS_STVARS_002_02----------------------#'
15SET @@GLOBAL.binlog_direct_non_transactional_updates=TRUE;
16SELECT @@GLOBAL.binlog_direct_non_transactional_updates;
17@@GLOBAL.binlog_direct_non_transactional_updates
181
19SET @@SESSION.binlog_direct_non_transactional_updates=TRUE;
20SELECT @@SESSION.binlog_direct_non_transactional_updates;
21@@SESSION.binlog_direct_non_transactional_updates
221
23'#---------------------BS_STVARS_002_03----------------------#'
24SELECT
25IF(@@GLOBAL.binlog_direct_non_transactional_updates, "ON", "OFF") = VARIABLE_VALUE
26FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
27WHERE VARIABLE_NAME='binlog_direct_non_transactional_updates';
28IF(@@GLOBAL.binlog_direct_non_transactional_updates, "ON", "OFF") = VARIABLE_VALUE
291
301 Expected
31SELECT COUNT(@@GLOBAL.binlog_direct_non_transactional_updates);
32COUNT(@@GLOBAL.binlog_direct_non_transactional_updates)
331
341 Expected
35SELECT COUNT(VARIABLE_VALUE)
36FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
37WHERE VARIABLE_NAME='binlog_direct_non_transactional_updates';
38COUNT(VARIABLE_VALUE)
391
401 Expected
41'#---------------------BS_STVARS_002_04----------------------#'
42SELECT
43IF(@@SESSION.binlog_direct_non_transactional_updates, "ON", "OFF") = VARIABLE_VALUE
44FROM INFORMATION_SCHEMA.SESSION_VARIABLES
45WHERE VARIABLE_NAME='binlog_direct_non_transactional_updates';
46IF(@@SESSION.binlog_direct_non_transactional_updates, "ON", "OFF") = VARIABLE_VALUE
471
481 Expected
49SELECT COUNT(@@SESSION.binlog_direct_non_transactional_updates);
50COUNT(@@SESSION.binlog_direct_non_transactional_updates)
511
521 Expected
53SELECT COUNT(VARIABLE_VALUE)
54FROM INFORMATION_SCHEMA.SESSION_VARIABLES
55WHERE VARIABLE_NAME='binlog_direct_non_transactional_updates';
56COUNT(VARIABLE_VALUE)
571
581 Expected
59'#---------------------BS_STVARS_002_05----------------------#'
60SELECT COUNT(@@binlog_direct_non_transactional_updates);
61COUNT(@@binlog_direct_non_transactional_updates)
621
631 Expected
64SELECT COUNT(@@local.binlog_direct_non_transactional_updates);
65COUNT(@@local.binlog_direct_non_transactional_updates)
661
671 Expected
68SELECT COUNT(@@SESSION.binlog_direct_non_transactional_updates);
69COUNT(@@SESSION.binlog_direct_non_transactional_updates)
701
711 Expected
72SELECT COUNT(@@GLOBAL.binlog_direct_non_transactional_updates);
73COUNT(@@GLOBAL.binlog_direct_non_transactional_updates)
741
751 Expected
76SET @@global.binlog_direct_non_transactional_updates= @start_value;
77