Debian Codegraph @

mysql-test/suite/sys_vars/r/end_markers_in_json_basic.result

raw
1 SET @start_global_value = @@global.end_markers_in_json;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 select @@global.end_markers_in_json;
6 @@global.end_markers_in_json
7 0
8 select @@session.end_markers_in_json;
9 @@session.end_markers_in_json
10 0
11 show global variables like 'end_markers_in_json';
12 Variable_name Value
13 end_markers_in_json OFF
14 show session variables like 'end_markers_in_json';
15 Variable_name Value
16 end_markers_in_json OFF
17 select * from performance_schema.global_variables where variable_name='end_markers_in_json';
18 VARIABLE_NAME VARIABLE_VALUE
19 end_markers_in_json OFF
20 select * from performance_schema.session_variables where variable_name='end_markers_in_json';
21 VARIABLE_NAME VARIABLE_VALUE
22 end_markers_in_json OFF
23 set global end_markers_in_json=1;
24 select @@global.end_markers_in_json;
25 @@global.end_markers_in_json
26 1
27 set session end_markers_in_json=1;
28 select @@session.end_markers_in_json;
29 @@session.end_markers_in_json
30 1
31 set global end_markers_in_json=0;
32 select @@global.end_markers_in_json;
33 @@global.end_markers_in_json
34 0
35 set session end_markers_in_json=0;
36 select @@session.end_markers_in_json;
37 @@session.end_markers_in_json
38 0
39 set session end_markers_in_json=on;
40 select @@session.end_markers_in_json;
41 @@session.end_markers_in_json
42 1
43 set session end_markers_in_json=off;
44 select @@session.end_markers_in_json;
45 @@session.end_markers_in_json
46 0
47 set session end_markers_in_json=default;
48 select @@session.end_markers_in_json;
49 @@session.end_markers_in_json
50 0
51 set global end_markers_in_json=1.1;
52 ERROR 42000: Incorrect argument type to variable 'end_markers_in_json'
53 set global end_markers_in_json=1e1;
54 ERROR 42000: Incorrect argument type to variable 'end_markers_in_json'
55 set session end_markers_in_json="foobar";
56 ERROR 42000: Variable 'end_markers_in_json' can't be set to the value of 'foobar'
57 SET @@global.end_markers_in_json = @start_global_value;
58 SELECT @@global.end_markers_in_json;
59 @@global.end_markers_in_json
60 0