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

Bug #119104	Workbench incorrectly marking "->>" as invalid syntax
Submitted:	2 Oct 2025 19:55	Modified:	11 Oct 2025 3:25
Reporter:	Aaron Mercier	Email Updates:
Status:	Won't Fix	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.

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.