boolean value true/false returned by JS stored function is interpreted as a string value.
General
Escalation
General
Escalation
Description
None
Environment
Activity
Show:
Details
Details
Assignee
Dmitry LenevReporter
parveez.baigNeeds QA
Yes
Priority
MediumSmart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Created February 18, 2025 at 5:53 AM
Updated February 18, 2025 at 11:21 AM
In MySQL, Upon creating stored function with return type boolean, it actually gets created with TINYINT return type.
In case of the normal stored function value true and false returned by the function are interpreted as 1 and 0 respectively. Whereas in case of JS stored function, the return value true/false is being interpreted as string true/false and the function throws an ERROR due to Incorrect Value to Integer.