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 Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:8.0.28, 8.0.32 OS:Windows (11)
Assigned to: 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