Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3664

Subquery wrapping affects performance

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.4.1
    • 1.4.4
    • None
    • None
    • 2020-2, 2020-3, 2020-4, 2020-5

    Description

      Wrapping a query in a subquery seems to impact performance in the 1.4 tree. See attached image for an example.

      Marked as to be investigated for 1.4.3 for now.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MCOL-3747 Regression in 1.4 working_ssb_compareLogOnly/sub/order_limit_sub

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              LinuxJedi Andrew Hutchings (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.5h
                  0.5h

                  Git Integration

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