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

          drrtuy Roman added a comment -

          4QA regression tests must pass.

          drrtuy Roman added a comment - 4QA regression tests must pass.

          Build verified: latest build for the develop branch

          engine: b2206521cea8c15c0bf6e8d217a08783c483a963
          server: 2b721f6864d135aa9a1916798e8daf29e213211e
          buildNo: 6716

          Execute all MTR test suites. All but few cases with known issues passed.

          Test result is the same as 22.08.8.

          dleeyh Daniel Lee (Inactive) added a comment - Build verified: latest build for the develop branch engine: b2206521cea8c15c0bf6e8d217a08783c483a963 server: 2b721f6864d135aa9a1916798e8daf29e213211e buildNo: 6716 Execute all MTR test suites. All but few cases with known issues passed. Test result is the same as 22.08.8.

          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.