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
        serg Sergei Golubchik created issue -
        serg Sergei Golubchik made changes -
        Field Original Value New Value
        Fix Version/s 5.5.23 [ 10600 ]
        Affects Version/s 5.5.22 [ 10501 ]
        serg Sergei Golubchik made changes -
        Fix Version/s 5.3.7 [ 10700 ]
        Fix Version/s 5.3.6 [ 10500 ]
        sanja Oleksandr Byelkin made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        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.
        serg Sergei Golubchik made changes -
        Fix Version/s 5.2.13 [ 10800 ]
        Fix Version/s 5.1.63 [ 10801 ]
        Fix Version/s 5.5.23 [ 10600 ]
        Affects Version/s 5.1.62 [ 10701 ]
        Affects Version/s 5.2.12 [ 10702 ]
        Affects Version/s 5.5.22 [ 10501 ]
        serg Sergei Golubchik made changes -
        Due Date 2012-04-28
        serg Sergei Golubchik made changes -
        Fix Version/s 5.5.24 [ 10703 ]
        Affects Version/s 5.5.23 [ 10600 ]
        sanja Oleksandr Byelkin made changes -
        Status In Progress [ 3 ] Open [ 1 ]
        sanja Oleksandr Byelkin made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        sanja Oleksandr Byelkin made changes -
        Status In Progress [ 3 ] Open [ 1 ]
        sanja Oleksandr Byelkin made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        sanja Oleksandr Byelkin made changes -
        Status In Progress [ 3 ] Open [ 1 ]
        sanja Oleksandr Byelkin made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        sanja Oleksandr Byelkin made changes -
        Status In Progress [ 3 ] Open [ 1 ]
        sanja Oleksandr Byelkin made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        sanja Oleksandr Byelkin made changes -
        Status In Progress [ 3 ] Open [ 1 ]
        sanja Oleksandr Byelkin made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        sanja Oleksandr Byelkin made changes -
        Status In Progress [ 3 ] Open [ 1 ]
        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
        serg Sergei Golubchik made changes -
        Fix Version/s 5.1.63 [ 10801 ]
        Resolution Fixed [ 1 ]
        Status Open [ 1 ] Closed [ 6 ]
        serg Sergei Golubchik made changes -
        Workflow defaullt [ 11306 ] MariaDB v2 [ 44610 ]
        ratzpo Rasmus Johansson (Inactive) made changes -
        Workflow MariaDB v2 [ 44610 ] MariaDB v3 [ 63963 ]
        serg Sergei Golubchik made changes -
        Workflow MariaDB v3 [ 63963 ] MariaDB v4 [ 144757 ]

        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.