search

webyog / sqlyog-community

Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solutions include SQL Diagnostic Manager for MySQL performance optimization and SQLyog for MySQL administration. More than 35,000 companies (including Amazon, IBM, Salesforce, AT&T, eBay, and GE) and 2.5 million users rely on Webyog's solutions to provide valuable insights into their databases. Webyog is an Idera, Inc. company.
https://webyog.com/
GNU General Public License v2.0
2.19k stars 322 forks source link

JSON viewer formatting issue #2296

Closed sibwy closed 2 years ago

sibwy commented 2 years ago

With the MariaDB servers, the JSON viewer editor does not format the JSON data, though the option "Format JSON data in JSON viewer" under "Tools -> Preferences -> General".

Reproduced with MariaDB v10.6.5, 10.3.22

The user report can be found in SF: 00951346

sibwy commented 2 years ago

On reviewing this issue, it is found that MariaDB implements JSON as a LONGTEXT, as the JSON data type contradicts the SQL standard.

In SQLyog, the JSON editor formatter currently works only if the datatype returned by the server is JSON. Therefore, closing this issue since it is not an SQLyog issue, rather a limitation with MariaDB.