[#MDEV-25956] SHOW EXPLAIN FOR should support FORMAT=JSON

[MDEV-25956] SHOW EXPLAIN FOR should support FORMAT=JSON Created: 2021-06-18 Updated: 2022-05-03 Resolved: 2022-04-29
Status:	Closed
Project:	MariaDB Server
Component/s:	Optimizer
Fix Version/s:	10.9.1

Type:

Task

Priority:

Minor

Reporter:

Vincent Pelletier

Assignee:

Unassigned

Resolution:

Duplicate

Votes:

Labels:

explain

Issue Links:

Relates
relates to	~~MDEV-27021~~	Extend SHOW EXPLAIN to support SHOW A...	Closed

Description

EXPLAIN FORMAT=JSON and ANALYZE FORMAT=JSON contain a treasure trove of information that non-json output does not convey.

I think it would be nice for SHOW EXPLAIN FOR to support FORMAT=JSON output for better feature parity with EXPLAIN.

Comments

Comment by Sergei Petrunia [ 2022-04-29 ]

Ok, ~~MDEV-27021~~ has been pushed into 10.9 tree and it includes support for SHOW EXPLAIN FORMAT=JSON (and for SHOW ANALYZE FORMAT=JSON).

Generated at Thu Feb 08 09:41:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.