Devart Forums

The perfectly legal MySQL syntax for JSON_UNQUOTE(JSON_EXTRACT(json_record, keyName)) is the syntax shortcut:

SELECT json_record->>keyName;

Although dbForge does not generate an error for the JSON_EXTRACT version of the inline path operator syntax (i.e.: json_record->keyName) if does not accept the input of the same for the JSON_UNQUOTE equivalent of the inline path operator syntax as documented here:

https://dev.mysql.com/doc/refman/5.7/en ... nline-path

Can this please resolved/corrected in ASAP please? Thank you.

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.

Hi there, any update on this fix yet please? Thank you in advance.

Sorry for the delay on this.

It's fixed in the latest build 8.1.45 https://www.devart.com/dbforge/mysql/st ... nload.html