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

Optimizer trace coverage of LATERAL DERIVED is insufficient

Details

    Description

      LATERAL DERIVED optimization is not covered well enough in Optimizer Trace.

      There's some coverage in MDEV-24325 but some important data is not printed.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36321 Split Materialized produces wrong out_rows estimates

          • Critical - Crashes, loss of data, severe memory leak.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36323 Split Materialized code: last_refills is never set in 11.0+

          • Critical - Crashes, loss of data, severe memory leak.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24325 Optimizer trace doesn't cover LATERAL DERIVED

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30878 Weird optimizer trace content for the LATERAL DERIVED table/access path

          • Critical - Crashes, loss of data, severe memory leak.
          • Confirmed

          Activity

            Transition Time In Source Status Execution Times
            Julien Fritsch made transition -
            Open Needs Feedback
            		1032d 5h 35m 1
            Valerii Kravchuk made transition -
            Needs Feedback Open
            		12m 40s 1
            Julien Fritsch made transition -
            Open Confirmed
            		9m 34s 1

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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