1
SELECT @@GLOBAL.binlog_format;
4
'#---------------------BS_STVARS_002_01----------------------#'
5
SELECT COUNT(@@GLOBAL.binlog_format);
6
COUNT(@@GLOBAL.binlog_format)
9
SELECT COUNT(@@SESSION.binlog_format);
10
COUNT(@@SESSION.binlog_format)
13
'#---------------------BS_STVARS_002_02----------------------#'
14
SET @@GLOBAL.binlog_format=1;
15
Expected error 'Read only variable'
16
Bug: Writeable static variable
17
SELECT COUNT(@@GLOBAL.binlog_format);
18
COUNT(@@GLOBAL.binlog_format)
21
SET @@SESSION.binlog_format=1;
22
Expected error 'Read only variable'
23
Bug: Writeable static variable
24
SELECT COUNT(@@SESSION.binlog_format);
25
COUNT(@@SESSION.binlog_format)
28
'#---------------------BS_STVARS_002_03----------------------#'
29
SELECT @@GLOBAL.binlog_format = VARIABLE_VALUE
30
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
31
WHERE VARIABLE_NAME='binlog_format';
32
@@GLOBAL.binlog_format = VARIABLE_VALUE
35
SELECT COUNT(@@GLOBAL.binlog_format);
36
COUNT(@@GLOBAL.binlog_format)
39
SELECT COUNT(VARIABLE_VALUE)
40
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
41
WHERE VARIABLE_NAME='binlog_format';
45
'#---------------------BS_STVARS_002_04----------------------#'
46
SELECT @@SESSION.binlog_format = VARIABLE_VALUE
47
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
48
WHERE VARIABLE_NAME='binlog_format';
49
@@SESSION.binlog_format = VARIABLE_VALUE
52
SELECT COUNT(@@SESSION.binlog_format);
53
COUNT(@@SESSION.binlog_format)
56
SELECT COUNT(VARIABLE_VALUE)
57
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
58
WHERE VARIABLE_NAME='binlog_format';
62
'#---------------------BS_STVARS_002_05----------------------#'
63
SELECT COUNT(@@binlog_format);
64
COUNT(@@binlog_format)
67
SELECT COUNT(@@local.binlog_format);
68
COUNT(@@local.binlog_format)
71
SELECT COUNT(@@SESSION.binlog_format);
72
COUNT(@@SESSION.binlog_format)
75
SELECT COUNT(@@GLOBAL.binlog_format);
76
COUNT(@@GLOBAL.binlog_format)