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

LP:686355 - Performance regression with sort_intersection in maria-5.1-wl21

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      The following query against the DBT-3 data set is much slower in maria-5.1-wl21 because it gets executed with sort_intersection

      SELECT COUNT( l_suppkey ) FROM lineitem WHERE (l_suppkey = 3 AND l_partkey = 255 ) OR (l_partkey BETWEEN 111 AND 244);

      The left side of the OR expression returns zero rows. Each side is easily computable with an index when executed separately.

      Attachments

        Activity

          People

            igor Igor Babaev
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.