I am new to JSON, so I'm not sure if this is a bug or an error on my part.

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");