Debian Codegraph @

mysql-test/suite/sys_vars/t/end_markers_in_json_basic.test

raw
1 SET @start_global_value = @@global.end_markers_in_json;
2 SELECT @start_global_value;
3
4 #
5 # exists as global and session
6 #
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 --disable_warnings
12 select * from performance_schema.global_variables where variable_name='end_markers_in_json';
13 select * from performance_schema.session_variables where variable_name='end_markers_in_json';
14 --enable_warnings
15
16 #
17 # show that it's writable
18 #
19 set global end_markers_in_json=1;
20 select @@global.end_markers_in_json;
21 set session end_markers_in_json=1;
22 select @@session.end_markers_in_json;
23 set global end_markers_in_json=0;
24 select @@global.end_markers_in_json;
25 set session end_markers_in_json=0;
26 select @@session.end_markers_in_json;
27 set session end_markers_in_json=on;
28 select @@session.end_markers_in_json;
29 set session end_markers_in_json=off;
30 select @@session.end_markers_in_json;
31 set session end_markers_in_json=default;
32 select @@session.end_markers_in_json;
33
34 #
35 # incorrect assignments
36 #
37 --error ER_WRONG_TYPE_FOR_VAR
38 set global end_markers_in_json=1.1;
39 --error ER_WRONG_TYPE_FOR_VAR
40 set global end_markers_in_json=1e1;
41 --error ER_WRONG_VALUE_FOR_VAR
42 set session end_markers_in_json="foobar";
43
44 SET @@global.end_markers_in_json = @start_global_value;
45 SELECT @@global.end_markers_in_json;