Bug #98323 Beautify query doesn't work when ->> operator is used
Submitted: 22 Jan 2020 7:19 Modified: 22 Jan 2020 7:27
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.19 OS:Any
Assigned to: CPU Architecture:Any

[22 Jan 2020 7:19] Daniël van Eeden
Description:
This query doesn't change on Ctrl+B:
SELECT a->>'$.foo' FROM (SELECT JSON_OBJECT('foo', 'bar') AS a) a;

But this one does:
SELECT a FROM (SELECT JSON_OBJECT('foo', 'bar') AS a) a;

The result is:
SELECT 
    a
FROM
    (SELECT JSON_OBJECT('foo', 'bar') AS a) a;

This one also fails to get 'beautified':
WITH foo AS (SELECT 1)
SELECT a FROM (SELECT JSON_OBJECT('foo', 'bar') AS a) a;

How to repeat:
See description

Suggested fix:
Make sure beautify query works with ->> and with WITH (CTE)
[22 Jan 2020 7:27] MySQL Verification Team
Hello Daniël,

Thank you for the report and feedback.
Verified as described on Win10 with WB 8.0.19.

regards,
Umesh