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

lp:967242 Wrong result with JOIN, AND in ON condition, multi-part key, GROUP BY, subquery and OR in WHERE

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 5.5.23, 5.3.5, 5.2.12, 5.1.62
        • Fix Version/s: 5.5.24, 5.3.7, 5.2.13
        • Component/s: None
        • Labels:
          None

          Gliffy Diagrams

            Attachments

              Activity

              Ascending order - Click to sort in descending order
              Hide
              Permalink
              sanja Oleksandr Byelkin added a comment - - edited

              This bug appeared to be legacy (repeatable without subqueries). It is repeatable in 5.1 and 5.3 and fixed in 5.5

              Show
              sanja Oleksandr Byelkin added a comment - - edited This bug appeared to be legacy (repeatable without subqueries). It is repeatable in 5.1 and 5.3 and fixed in 5.5
              Hide
              Permalink
              sanja Oleksandr Byelkin added a comment -

              the original test suite still repeatable in 5.5 so fix of query with rand should be modified for subselects.

              Show
              sanja Oleksandr Byelkin added a comment - the original test suite still repeatable in 5.5 so fix of query with rand should be modified for subselects.
              Hide
              Permalink
              sanja Oleksandr Byelkin added a comment -

              The fix of this bug committed for review.

              Show
              sanja Oleksandr Byelkin added a comment - The fix of this bug committed for review.
              Hide
              Permalink
              serg Sergei Golubchik added a comment -

              pushed

              Show
              serg Sergei Golubchik added a comment - pushed

                People

                • Assignee:
                  sanja Oleksandr Byelkin
                  Reporter:
                  serg Sergei Golubchik
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Due:
                    Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 30 minutes
                    30m