Bug #78421 Describe JSON output for explain and allow validation

• Submitted: 13 Sep 2015 19:03
• Reporter: Daniël van Eeden (OCA)
• Status: Open
• Category: MySQL Server: Optimizer
• Severity: S4 (Feature request)
• Version: 5.7.8
• OS: Any
• CPU Architecture: Any
• Tags: explain, json, validate

[13 Sep 2015 19:03] Daniël van Eeden

Description:
I think a JSON schema (http://json-schema.org/) should be shipped with the server. This makes it easy to validate the output.

Example data:
https://bugs.mysql.com/file.php?id=22080&bug_id=67023

Example schema:
https://bugs.mysql.com/file.php?id=22081&bug_id=67023

Related:
Bug #67023 	EXPLAIN FORMAT=json output not documented.

How to repeat:
See description