[9.0.391]: Incorrect representation for NULL values in JSON columns!

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

[9.0.391]: Incorrect representation for NULL values in JSON columns!

Post by tfrancois » Wed 26 Aug 2020 18:16

I discovered another issue with the latest build related to the JSON datatype.

As shown in the image below, JSON columns that contain NULL value are shown in the IDE as if the string 'Null' is present in the column rather than the normal representation of NULL values for all other columns: (null).

I actually spent time refactoring some my code thinking I was incorrectly writing to my tables for NULL values until I realized this was an issue with the latest build.

Please fix this. This and the other issue I reported with JSON-returning functions have been very negatively impactful to my productivity with the latest build release (9.0.391).

I love the product and rely on it HEAVILY so please let me know when a hotfix can be provided that resolves these issues.

Thank you.


Image

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

Re: [9.0.391]: Incorrect representation for NULL values in JSON columns!

Post by tfrancois » Tue 01 Sep 2020 01:26

Respectfully, Support Team, would appreciate some feedback on this issue please. Thank you.

alexa

Re: [9.0.391]: Incorrect representation for NULL values in JSON columns!

Post by alexa » Tue 01 Sep 2020 11:15

Sorry for the delay on this.

We were able to reproduce this issue and will fix it in one of the next product builds.

Post Reply