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

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5.23, 5.3.5, 5.2.12, 5.1.62
    • 5.5.24, 5.3.7, 5.2.13
    • None
    • None

    Attachments

      Activity

        Ascending order - Click to sort in descending order
        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

        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
        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.

        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.
        sanja Oleksandr Byelkin added a comment -

        The fix of this bug committed for review.

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

        pushed

        serg Sergei Golubchik added a comment - pushed

        People

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