Details

    • 2017-02, 10.1.22

    Description

      set global optimizer_switch="engine_condition_pushdown=on"

      Ouch! It is now pulling back the entire table 200 rows at a time.

      Query: SELECT DISTINCT x FROM table
      PRIMARY KEY (x,y,z)
      Backend queries: SELECT x FROM table x > 12345 ORDER BY x,y,z LIMIT 200.

      (And it is taking ​much​ longer than when ecp=OFF)

      Question 1: Why fetch the table rather than executing the query?

      Question 2: When you have a multi-part PK, that code is likely to be "wrong". Note that it always compared only x, not y and z. And it always said 200.

      Attachments

        Issue Links

          Activity

            The fix was committed in: https://github.com/MariaDB/server/commit/ab841ac6c7eed993d4a69f8f205b97d43ebc3847 and merged into the 10.2-spider branch. Note that this will be released in a 10.3 release of MariaDB.

            jacob-mathew Jacob Mathew (Inactive) added a comment - The fix was committed in: https://github.com/MariaDB/server/commit/ab841ac6c7eed993d4a69f8f205b97d43ebc3847 and merged into the 10.2-spider branch. Note that this will be released in a 10.3 release of MariaDB.

            It shouldn't really be closed until it makes to a main tree (10.3 in this case).

            elenst Elena Stepanova added a comment - It shouldn't really be closed until it makes to a main tree (10.3 in this case).

            Note that builds from the 10.2-spider branch will be given to customers. We therefore need to be able to mark bugs fixed in that branch as CLOSED.

            jacob-mathew Jacob Mathew (Inactive) added a comment - Note that builds from the 10.2-spider branch will be given to customers. We therefore need to be able to mark bugs fixed in that branch as CLOSED.

            Code needs to fixed according to review

            monty Michael Widenius added a comment - Code needs to fixed according to review

            after-review fixes are in MDEV-13282

            serg Sergei Golubchik added a comment - after-review fixes are in MDEV-13282

            People

              jacob-mathew Jacob Mathew (Inactive)
              rjasdf Rick James (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.