1SET @start_global_value = @@global.end_markers_in_json; 2SELECT @start_global_value; 3@start_global_value 40 5select @@global.end_markers_in_json; 6@@global.end_markers_in_json 70 8select @@session.end_markers_in_json; 9@@session.end_markers_in_json 100 11show global variables like 'end_markers_in_json'; 12Variable_name Value 13end_markers_in_json OFF 14show session variables like 'end_markers_in_json'; 15Variable_name Value 16end_markers_in_json OFF 17select * from information_schema.global_variables where variable_name='end_markers_in_json'; 18VARIABLE_NAME VARIABLE_VALUE 19END_MARKERS_IN_JSON OFF 20select * from information_schema.session_variables where variable_name='end_markers_in_json'; 21VARIABLE_NAME VARIABLE_VALUE 22END_MARKERS_IN_JSON OFF 23set global end_markers_in_json=1; 24select @@global.end_markers_in_json; 25@@global.end_markers_in_json 261 27set session end_markers_in_json=1; 28select @@session.end_markers_in_json; 29@@session.end_markers_in_json 301 31set global end_markers_in_json=0; 32select @@global.end_markers_in_json; 33@@global.end_markers_in_json 340 35set session end_markers_in_json=0; 36select @@session.end_markers_in_json; 37@@session.end_markers_in_json 380 39set session end_markers_in_json=on; 40select @@session.end_markers_in_json; 41@@session.end_markers_in_json 421 43set session end_markers_in_json=off; 44select @@session.end_markers_in_json; 45@@session.end_markers_in_json 460 47set session end_markers_in_json=default; 48select @@session.end_markers_in_json; 49@@session.end_markers_in_json 500 51set global end_markers_in_json=1.1; 52ERROR 42000: Incorrect argument type to variable 'end_markers_in_json' 53set global end_markers_in_json=1e1; 54ERROR 42000: Incorrect argument type to variable 'end_markers_in_json' 55set session end_markers_in_json="foobar"; 56ERROR 42000: Variable 'end_markers_in_json' can't be set to the value of 'foobar' 57SET @@global.end_markers_in_json = @start_global_value; 58SELECT @@global.end_markers_in_json; 59@@global.end_markers_in_json 600 61