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

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.2.12
    • 5.2.13
    • None
    • None

    Attachments

      Activity

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

        according to the bugreport 5.3 and above are not affected

        sanja Oleksandr Byelkin added a comment - according to the bugreport 5.3 and above are not affected
        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.

        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

          sanja Oleksandr Byelkin
          sanja Oleksandr Byelkin
          Votes:
          0 Vote for this issue
          Watchers:
          1 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.