Details
Description
MDEV-24325 added support for some details related to LATERAL DERIVED optimization into 10.6+. This request is to back port them to 10.4 and 10.5, as this optimization is enabled by default and in some cases are wrongly used. Having the details in the optimizer trace would help a lot to figure out what caused using the bad plan involving LATERAL DERIVED.
Attachments
Issue Links
- is blocked by
-
MDEV-24325 Optimizer trace doesn't cover LATERAL DERIVED
-
- Closed
-
MDEV-26301introduced changes to how the optimizer handles LATERAL DERIVED (aka Split Materialized).Besides the fix for
MDEV-26301, there was a patch pushed that improved Optimizer Trace coverage:commit ed3e6f66a265952afded33fb134f6f8bcc31aa89
Author: Sergei Petrunia <sergey@mariadb.com>
Date: Wed May 3 13:49:32 2023 +0300
MDEV-26301: Split optimization refills: Optimizer Trace coverage
Add Optimizer Trace printouts.
That commit covers what was required to be done in this MDEV.