Bug #103689 MySQL Workbench incorrectly registering syntax error for json_value returning
Submitted: 13 May 23:15 Modified: 14 May 6:26
Reporter: Justin Levene Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:8.0.23, 8.0.25 OS:Microsoft Windows (10)
Assigned to: CPU Architecture:x86

[13 May 23:15] Justin Levene
MySQL Workbench is incorrectly marking a syntax error when using "returning" in "json_value"

How to repeat:
Type in the following in an SQL window:

select json_value('{"a":1, "b":2, "c":3}', "$.b" RETURNING UNSIGNED);

MySQL classes this as a syntax error and thus won't compile a function or procedure that has this in it.

In the sql window you can obviously execute the command even though MYSQL marks it as an error, however it prevents you using it in a procedure or function

Suggested fix:
To class this type of expression as acceptable
[14 May 6:26] MySQL Verification Team
Hello Justin Levene,

Thank you for the report and feedback.