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

Performance regression in LIKE & NOT LIKE

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 1.4.1
    • 1.4.3
    • None
    • None
    • 2020-1, 2020-2

    Description

      LIKE and NOT LIKE perform significantly worse in 1.4 vs 1.2. The assumed guess is this falls back to non-select-handler based methods. See attached image for example.

      Attachments

        Issue Links

          Activity

            LinuxJedi Andrew Hutchings (Inactive) created issue -
            toddstoffel Todd Stoffel (Inactive) made changes -
            Field Original Value New Value
            Rank Ranked higher
            David.Hall David Hall (Inactive) made changes -
            Story Points 2
            David.Hall David Hall (Inactive) made changes -
            Story Points 2 3
            David.Hall David Hall (Inactive) made changes -
            Sprint 2020-1 [ 376 ]
            David.Hall David Hall (Inactive) made changes -
            Rank Ranked lower
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            David.Hall David Hall (Inactive) made changes -
            Sprint 2020-1 [ 376 ] 2020-1, 2020-2 [ 376, 382 ]
            drrtuy Roman made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            drrtuy Roman made changes -
            Status In Progress [ 3 ] In Testing [ 10301 ]
            drrtuy Roman made changes -
            Assignee Roman [ drrtuy ] Daniel Lee [ dleeyh ]
            drrtuy Roman made changes -
            Priority Major [ 3 ] Minor [ 4 ]
            gdorman Gregory Dorman (Inactive) made changes -
            Priority Minor [ 4 ] Major [ 3 ]
            gdorman Gregory Dorman (Inactive) made changes -
            Assignee Daniel Lee [ dleeyh ] Roman [ drrtuy ]
            gdorman Gregory Dorman (Inactive) made changes -
            Priority Major [ 3 ] Blocker [ 1 ]
            dleeyh Daniel Lee (Inactive) made changes -
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            David.Hall David Hall (Inactive) made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            David.Hall David Hall (Inactive) made changes -
            Assignee Roman [ drrtuy ] David Hall [ david.hall ]
            David.Hall David Hall (Inactive) made changes -
            Assignee David Hall [ david.hall ] Roman [ drrtuy ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            drrtuy Roman made changes -
            David.Hall David Hall (Inactive) made changes -
            Status In Review [ 10002 ] In Testing [ 10301 ]
            David.Hall David Hall (Inactive) made changes -
            Assignee Roman [ drrtuy ] Daniel Lee [ dleeyh ]
            dleeyh Daniel Lee (Inactive) made changes -
            issue.field.resolutiondate 2020-02-12 16:05:49.0 2020-02-12 16:05:49.414
            dleeyh Daniel Lee (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status In Testing [ 10301 ] Closed [ 6 ]
            toddstoffel Todd Stoffel (Inactive) made changes -
            Team ColumnStore Team
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher

            People

              dleeyh Daniel Lee (Inactive)
              LinuxJedi Andrew Hutchings (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.