I am using Valentina Studio 8.3.5.
I am attempting to use a JSON string in a stored procedure. The following code does not produce the string that I expect to see.
begin
declare v_json string;
set v_json = json_build_object(
'name', 'My Name',
'date_time', '07/12/2018 17:55:00',
'bool_value', true
);
print v_json;
end
-- Result is {"name":"","date_time":7,"bool_value":1}
Also, anytime I attempt to use the json_extract_path function, Valentina Studio crashes. For example:
print json_extract_path(v_json,"date_time");