The pros and cons to use proper and improper characteristics for a MySQL function?
I created test function with the proper characteristic DETERMINISTIC as shown below because it always produces the same result 3 according to the doc: CREATE FUNCTION test() RETURNS INT DETERMINISTIC -- Here RETURN 3; And, I also created test function…