1
SET @start_global_value = @@global.end_markers_in_json;
2
SELECT @start_global_value;
5
# exists as global and session
7
select @@global.end_markers_in_json;
8
select @@session.end_markers_in_json;
9
show global variables like 'end_markers_in_json';
10
show session variables like 'end_markers_in_json';
11
select * from information_schema.global_variables where variable_name='end_markers_in_json';
12
select * from information_schema.session_variables where variable_name='end_markers_in_json';
15
# show that it's writable
17
set global end_markers_in_json=1;
18
select @@global.end_markers_in_json;
19
set session end_markers_in_json=1;
20
select @@session.end_markers_in_json;
21
set global end_markers_in_json=0;
22
select @@global.end_markers_in_json;
23
set session end_markers_in_json=0;
24
select @@session.end_markers_in_json;
25
set session end_markers_in_json=on;
26
select @@session.end_markers_in_json;
27
set session end_markers_in_json=off;
28
select @@session.end_markers_in_json;
29
set session end_markers_in_json=default;
30
select @@session.end_markers_in_json;
33
# incorrect assignments
35
--error ER_WRONG_TYPE_FOR_VAR
36
set global end_markers_in_json=1.1;
37
--error ER_WRONG_TYPE_FOR_VAR
38
set global end_markers_in_json=1e1;
39
--error ER_WRONG_VALUE_FOR_VAR
40
set session end_markers_in_json="foobar";
42
SET @@global.end_markers_in_json = @start_global_value;
43
SELECT @@global.end_markers_in_json;