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

fix LP BUG#993459 Execution of PS for a query with GROUP BY returns wrong result

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 5.2.12
        • Fix Version/s: 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 -

              according to the bugreport 5.3 and above are not affected

              Show
              sanja Oleksandr Byelkin added a comment - according to the bugreport 5.3 and above are not affected
              Hide
              Permalink
              sanja Oleksandr Byelkin added a comment -

              We do not have problem in 5.3 because we postpone execution of constant ORDER BY/GROUP BY with subqueries but in 5.2 we have special condition in remove_const() which evaluates and removes constant expression with subqueries.

              IMHO it will be better do not fix 5.2 and we have in fixed in 5.3 and up due to other order of OPTIMIZATION/EXECUTION for subqueries.

              Show
              sanja Oleksandr Byelkin added a comment - We do not have problem in 5.3 because we postpone execution of constant ORDER BY/GROUP BY with subqueries but in 5.2 we have special condition in remove_const() which evaluates and removes constant expression with subqueries. IMHO it will be better do not fix 5.2 and we have in fixed in 5.3 and up due to other order of OPTIMIZATION/EXECUTION for subqueries.

                People

                • Assignee:
                  sanja Oleksandr Byelkin
                  Reporter:
                  sanja Oleksandr Byelkin
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: