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

Disable GROUP BY Pushdown by default

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 22.08.7
    • 23.02.1
    • MDB Plugin
    • None
    • 2022-23

    Description

      The mentioned GROUP BY pushdown proved to be error-prone, e.g. its execution starts after optimize phase so MDB optimizer might has rewritten JOIN conditions dropping some of them. The optimized conditions forces the query to error-out. Moreover this pushdown method are rarely called b/c it is the last in the precedence of pushdown methods available:

      • select handler
      • derived handler
      • group by handler
      • table scan with conditions
        Deactivation of GBH might implicitly affects the variety of queries that MCS can process so at least full test001 should be run with the patch.

      Attachments

        Activity

          People

            drrtuy Roman
            drrtuy Roman
            Leonid Fedorov Leonid Fedorov
            Daniel Lee Daniel Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.