MySQL Bugs: #87828: Capitalised NULL values are invlalid for exported data in JSON format

Bug #87828	Capitalised NULL values are invlalid for exported data in JSON format
Submitted:	21 Sep 2017 15:41	Modified:	22 Sep 2017 6:03
Reporter:	Danish Bhatti	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	6.3.6	OS:	Linux (Ubuntu 16.04.2 LTS)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Some rows in my table contain NULL data. When I exported this table in JSON format, NULL was replicated in the exported file however it was capitalized which is invalid and caused python's json decoder to fail. All NULL values must be lowercase i.e. null for valid json.

How to repeat:
export a table that has rows with some NULL values

Suggested fix:
export NULL as null

Hello Danish,

Thank you for the report.
This is duplicate of Bug #81331, which is fixed in 6.3.7 release, and here's the changelog entry:

Exporting data to JSON was exporting NULL values as NULL instead of null,
thus breaking the JSON output.

Thanks,
Umesh