Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-30876

Back port LATERAL DERIVED coverage in optimizer trace

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

          Activity

            MDEV-26301 introduced 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.

            psergei Sergei Petrunia added a comment - MDEV-26301 introduced 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.

            People

              Unassigned Unassigned
              valerii Valerii Kravchuk
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.