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

LATERAL DERIVED: Optimizer trace insufficient, odd computations

    XMLWordPrintable

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.

      (See comments below. It's not just about trace, carefully reading what is traced reveals further issues).

      Attachments

        Issue Links

          includes

          Task - A task that needs to be done. MDEV-36321 Indexes on derived tables with GROUP BY produce wrong out_rows estimates

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

          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.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-36321 Indexes on derived tables with GROUP BY produce wrong out_rows estimates

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

          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.
          • Closed

          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.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 1d 7h
                  1d 7h
                  Remaining:
                  Time Spent - 0.5d Remaining Estimate - 1d 3h
                  1d 3h
                  Logged:
                  Time Spent - 0.5d Remaining Estimate - 1d 3h
                  0.5d

                  Git Integration

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