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

MySQL Bug 69581

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.0.4, 5.5.33a
        • Fix Version/s: 5.5.34, 10.0.6
        • Component/s: None
        • Labels:

          Description

          I verified that Bug 69581 also affects 10.0. Since this is an incorrect result issue, creating a tracking bug here.

            Gliffy Diagrams

              Attachments

                Issue Links

                duplicates

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5112 InnoDB index intersection returns less results than expected

                • Major - Major loss of function.
                • Closed
                relates to

                Bug - A problem which impairs or prevents the functions of the product. MDEV-6151 Wrong result (missing row) with LEFT JOIN, HAVING and ORDER BY

                • Major - Major loss of function.
                • Closed
                links to

                Web Link Bug #69581 - InnoDB index intersection returns less results than expected

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  serg Sergei Golubchik added a comment -

                  does it affect 5.5?

                  Show
                  serg Sergei Golubchik added a comment - does it affect 5.5?
                  Hide
                  Permalink
                  greenman Ian Gilfillan added a comment -

                  This affects 5.5.33a as well

                  Show
                  greenman Ian Gilfillan added a comment - This affects 5.5.33a as well
                  Hide
                  Permalink
                  igor Igor Babaev added a comment - - edited

                  This problem was reported in MDEV-5112 (see my comments there)

                  Show
                  igor Igor Babaev added a comment - - edited This problem was reported in MDEV-5112 (see my comments there)
                  Hide
                  Permalink
                  psergey Sergei Petrunia added a comment -

                  The fix in mysql-5.6 is correct, but is incomplete. See comments for MDEV-5112.

                  Show
                  psergey Sergei Petrunia added a comment - The fix in mysql-5.6 is correct, but is incomplete. See comments for MDEV-5112 .
                  Hide
                  Permalink
                  psergey Sergei Petrunia added a comment -

                  Fix for MDEV-5112 is pushed into MariaDB 5.5. MDEV-5177 (MySQL Bug#70703) is still not fixed.

                  Show
                  psergey Sergei Petrunia added a comment - Fix for MDEV-5112 is pushed into MariaDB 5.5. MDEV-5177 (MySQL Bug#70703) is still not fixed.

                    People

                    • Assignee:
                      psergey Sergei Petrunia
                      Reporter:
                      jeremycole Jeremy Cole
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      7 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: