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.
JSON inline path operator ->> not supported on dbForge 8.1.22!
Re: JSON inline path operator ->> not supported on dbForge 8.1.22!
We will fix this issue in one of the next product builds and will notify you once it's available for downloading.
Re: JSON inline path operator ->> not supported on dbForge 8.1.22!
Hi there, any update on this fix yet please? Thank you in advance.
Re: JSON inline path operator ->> not supported on dbForge 8.1.22!
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
It's fixed in the latest build 8.1.45 https://www.devart.com/dbforge/mysql/st ... nload.html