MySQL Bugs: #119104: Workbench incorrectly marking "->>" as invalid syntax

Bug #119104	Workbench incorrectly marking "->>" as invalid syntax
Submitted:	2 Oct 19:55	Modified:	11 Oct 3:25
Reporter:	Aaron Mercier	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	8.0.42	OS:	MacOS (Sequoia 15.1.1)
Assigned to:		CPU Architecture:	ARM

Description:
If I type a query that uses the "->>" unquoting extraction operator, workbench underlines the second ">" with a red line which makes it appear as if it is an invalid query operator. But the query runs successfully without error. 

How to repeat:
Type the following query in a sql file editor.

select Definition->>'$.IsEnabled'
from user;

And note the error underline under the ">"

If you have a "user" table with a "Definition" longtext column it will execute ok.

Suggested fix:
Correctly handle the "->>" operator in the syntax check.

Thank you for your report.

Have you considered trying MySQL Shell extension for Visual Studio Code?
https://dev.mysql.com/doc/mysql-shell-gui/en/mysql-shell-for-vscode-setup.html

I have not but will look into it. It would still be nice to get this bug fixed regardless.