Devart Forums

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?

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

Please try the latest build.

Bug still exists in 9.0.435.

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