Bug #103689 MySQL Workbench incorrectly registering syntax error for json_value returning

• Submitted: 13 May 2021 23:15
• Modified: 14 May 2021 6:26
• Reporter: Justin Levene
• Status: Verified
• Category: MySQL Workbench: SQL Editor
• Severity: S2 (Serious)
• Version: 8.0.23, 8.0.25, 8.0.26
• OS: Windows (10)
• CPU Architecture: x86

[13 May 2021 23:15] Justin Levene

Description:
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 2021 6:26] MySQL Verification Team

Hello Justin Levene,

Thank you for the report and feedback.

regards,
Umesh

[8 Dec 2021 13:31] MySQL Verification Team

Bug #105737 marked as duplicate of this one.