MySQL Bugs: #101704: JSON type in CAST() and CONVERT() is recognized as error in model editors

Bug #101704	JSON type in CAST() and CONVERT() is recognized as error in model editors
Submitted:	21 Nov 2020 5:02	Modified:	21 Nov 2020 7:46
Reporter:	Ju-Myoung Kim	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	8.0.22	OS:	Windows (Microsoft Windows 10 Pro)
Assigned to:		CPU Architecture:	x86
Tags:	WBBugReporter

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Editor in model recognizes JSON type in CAST() and CONVERT() as error, which is fine in SQL editor in a running server.

How to repeat:
1. Open a model.
2. Select a schema.
3. Add a routine.
4. Add a statement "SELECT CAST(1 AS JSON);"
5. The editor shows error on the line.

This bug prevents exporting a model to a script.

There is no problem in exporting model to script.

Hello Ju-Myoung Kim,

Thank you for the report and test case.

regards,
Umesh