Bug #110642 using JSON_VALUE(Table_Name,'$.column_name') in view is causing DDL syntax error

• Submitted: 9 Apr 2023 23:13
• Modified: 10 Apr 2023 3:36
• Reporter: Chase Fashing
• Status: Won't Fix
• Category: MySQL Workbench
• Severity: S1 (Critical)
• Version: 8.0.28, 8.0.32
• OS: Windows (11)
• CPU Architecture: Any (i9)

[9 Apr 2023 23:13] Chase Fashing

Description:
Any View that is added to the schema immediately alerts the user with a DLL parsing error. Upon further inspection, I found that """JSON_VALUE(Table_Name,'$.column_name')""" turns into """JSON_VALUE(Table_Name,'$.column_name' returning char(512))"""
This causes a syntax error, so the reverse engineer does not work for that view. I tried workarounds but after a day, I gave up.

How to repeat:
Create a table(maybe not even neccessary) with a JSON type column. Right Click Views in the Mysql workbench and click create view. 
TYPE IN:
"""
CREATE VIEW `Test_View` AS
select JSON_VALUE(additional_info,'$.team_number')
from Event_Dogs 
"""
Anything can be used naming-wise. An error will pop up saying error parsing DLL. Upon viewing the DLL, you can see "returning char(512)" was added.

[10 Apr 2023 3:36] MySQL Verification Team

Hello Chase Fashing,

Thank you for the report and feedback.
Verified as described.

regards,
Umesh

[14 Sep 18:06] Omer Barnir

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.