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

        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

        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.

        The fix of this bug committed for review.

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

        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.