[BUG] dbForge Studio 2020 MySQL Enterprise - IDE fails on JSON keys with a hyphen

[Requnix]

Version: 9.0.391
Platform: Windows 10

The IDE gives the below error when you try to do a SELECT statement using a JSON Key that has a hyphen. I can't seem to find confirmation as to whether this is a MySQL limitation or not (it's definitely not a problem with JSON and the data can be inserted just fine). I saw talk about it back in 2016 but that's it.

Is this a MySQL limitation, or a dbForge IDE Smartcontent issue?

[alexa]

We just released dbForge Studio for MySQL, v9.0.435 https://www.devart.com/dbforge/mysql/studio/download.html

Please try the latest build.

[Requnix]

Bug still exists in 9.0.435.

[alexa]

This appears to be the error of the server https://stackoverflow.com/questions/35735454/mysql-json-extract-path-expression-error

You should use double quotes if there is a hyphen

Code: Select all

'$."json-message"'