1SET @start_value = @@global.read_only;
2SELECT @start_value;
3@start_value
40
5'#--------------------FN_DYNVARS_139_01------------------------#'
6SET @@global.read_only = 1;
7SET @@global.read_only = DEFAULT;
8SELECT @@global.read_only;
9@@global.read_only
100
11'#---------------------FN_DYNVARS_139_02-------------------------#'
12SET @@global.read_only = @start_value;
13SELECT @@global.read_only = 0;
14@@global.read_only = 0
151
16'#--------------------FN_DYNVARS_139_03------------------------#'
17SET @@global.read_only = 0;
18SELECT @@global.read_only;
19@@global.read_only
200
21SET @@global.read_only = 1;
22SELECT @@global.read_only;
23@@global.read_only
241
25SET @@global.read_only = TRUE;
26SELECT @@global.read_only;
27@@global.read_only
281
29SET @@global.read_only = FALSE;
30SELECT @@global.read_only;
31@@global.read_only
320
33SET @@global.read_only = ON;
34SELECT @@global.read_only;
35@@global.read_only
361
37SET @@global.read_only = OFF;
38SELECT @@global.read_only;
39@@global.read_only
400
41'#--------------------FN_DYNVARS_139_04-------------------------#'
42SET @@global.read_only = -1;
43ERROR 42000: Variable 'read_only' can't be set to the value of '-1'
44SELECT @@global.read_only;
45@@global.read_only
460
47SET @@global.read_only = 4294967296;
48ERROR 42000: Variable 'read_only' can't be set to the value of '4294967296'
49SELECT @@global.read_only;
50@@global.read_only
510
52SET @@global.read_only = 10240022115;
53ERROR 42000: Variable 'read_only' can't be set to the value of '10240022115'
54SELECT @@global.read_only;
55@@global.read_only
560
57SET @@global.read_only = 10000.01;
58ERROR 42000: Incorrect argument type to variable 'read_only'
59SELECT @@global.read_only;
60@@global.read_only
610
62SET @@global.read_only = -1024;
63ERROR 42000: Variable 'read_only' can't be set to the value of '-1024'
64SELECT @@global.read_only;
65@@global.read_only
660
67SET @@global.read_only = 42949672950;
68ERROR 42000: Variable 'read_only' can't be set to the value of '42949672950'
69SELECT @@global.read_only;
70@@global.read_only
710
72SET @@global.read_only = 'test';
73ERROR 42000: Variable 'read_only' can't be set to the value of 'test'
74SELECT @@global.read_only;
75@@global.read_only
760
77'#-------------------FN_DYNVARS_139_05----------------------------#'
78SET @@session.read_only = 0;
79ERROR HY000: Variable 'read_only' is a GLOBAL variable and should be set with SET GLOBAL
80SELECT @@read_only;
81@@read_only
820
83'#----------------------FN_DYNVARS_139_06------------------------#'
84SELECT IF(@@global.read_only, "ON", "OFF") = VARIABLE_VALUE
85FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
86WHERE VARIABLE_NAME='read_only';
87IF(@@global.read_only, "ON", "OFF") = VARIABLE_VALUE
881
89SELECT IF(@@read_only, "ON", "OFF") = VARIABLE_VALUE
90FROM INFORMATION_SCHEMA.SESSION_VARIABLES
91WHERE VARIABLE_NAME='read_only';
92IF(@@read_only, "ON", "OFF") = VARIABLE_VALUE
931
94'#---------------------FN_DYNVARS_139_07----------------------#'
95SET @@global.read_only = 1;
96SELECT @@read_only = @@global.read_only;
97@@read_only = @@global.read_only
981
99'#---------------------FN_DYNVARS_139_08----------------------#'
100SET read_only = 1;
101ERROR HY000: Variable 'read_only' is a GLOBAL variable and should be set with SET GLOBAL
102SELECT @@read_only;
103@@read_only
1041
105SELECT local.read_only;
106ERROR 42S02: Unknown table 'local' in field list
107SELECT global.read_only;
108ERROR 42S02: Unknown table 'global' in field list
109SELECT read_only = @@session.read_only;
110ERROR 42S22: Unknown column 'read_only' in 'field list'
111SET @@global.read_only = @start_value;
112SELECT @@global.read_only;
113@@global.read_only
1140
115