Server crashes in select_describe on EXPLAIN with materialization+semijoin, 2 nested subqueries, aggregate functions

Description

Note: It might belong to Timour, because the problem appeared with revno 3445 (MDEV-193), but since it requires semijoin, assigning to Sergei for starters. Please re-assign if needed.

bzr version-info

Also reproducible on revno 3445. Not reproducible on revno 3444.
Reproducible with MyISAM, Aria, InnoDB.

Minimal optimizer_switch:
materialization=on,semijoin=on

Default optimizer_switch:

Test case:

Environment

None

Assignee

Sergei Petrunia

Reporter

Elena Stepanova

Labels

None

Fix versions

Affects versions

Priority

Critical
Configure