Bug #101946 "Visual Explain" raises 'NoneType' object has no attribute 'do_relayout' error

• Submitted: 10 Dec 2020 7:00
• Modified: 10 Jan 2021 8:40
• Reporter: lau ho
• Status: No Feedback
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 8.0.22
• OS: Windows (6.1.7601)
• CPU Architecture: Any

[10 Dec 2020 7:00] lau ho

Description:
Raw Explain Data

1	PRIMARY	<derived2>		ALL					1258	100	
2	DERIVED	tp		index		idx_****_****_code	1022		629	100	Using index; Using temporary; Using filesort
2	DERIVED	<derived3>		ALL					2	100	Using where; Using join buffer (hash join)
3	DERIVED	rt		ALL	PRIMARY				1	100	Using where; Using temporary; Using filesort
3	DERIVED	mec		index	PRIMARY,code	code	22		1	100	Using where; Using index; Using join buffer (hash join)
3	DERIVED	r		ref	fk_****_***_id_idx	fk_****_***_id_idx	5	*******.mec.id	2	1.88	Using index condition; Using where
3	DERIVED	rr		ref	fk_****_***********_idx	fk_****_***********_idx	4	****_******.r.id	1	100	Using where
3	DERIVED	tbaec		ALL					3268	1	Using where; Using join buffer (hash join)
3	DERIVED	bpi		eq_ref	PRIMARY	PRIMARY	4	*******.*****.*******_***_****_id	1	100	Using where
3	DERIVED	b		eq_ref	PRIMARY	PRIMARY	4	*******.***.*******_id	1	100

How to repeat:
Explain a view which involve CTE expression

[10 Dec 2020 7:03] lau ho

Error Dialog "'NoneType' object has no attribute 'do_relayout'"

Attachment: 20201210_1501.png (image/png, text), 8.06 KiB.

[10 Dec 2020 8:40] MySQL Verification Team

Thank you for the bug report. Please provide the create view create tableview which provoke on your side this issue. Thanks in advance.

[11 Jan 2021 1:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

[17 Nov 2022 4:18] Le Quan

Same error in macos