JSON inline path operator ->> not supported on dbForge 8.1.22!

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
tfrancois
Posts: 44
Joined: Mon 11 Jun 2018 23:58

JSON inline path operator ->> not supported on dbForge 8.1.22!

Post by tfrancois » Wed 20 Feb 2019 21:29

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.

alexa

Re: JSON inline path operator ->> not supported on dbForge 8.1.22!

Post by alexa » Mon 04 Mar 2019 14:12

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

tfrancois
Posts: 44
Joined: Mon 11 Jun 2018 23:58

Re: JSON inline path operator ->> not supported on dbForge 8.1.22!

Post by tfrancois » Tue 02 Jul 2019 23:33

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

alexa

Re: JSON inline path operator ->> not supported on dbForge 8.1.22!

Post by alexa » Wed 03 Jul 2019 09:23

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

Post Reply