Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10006 optimizer doesn't convert outer join to inner on views with WHERE clause
  3. MDEV-10031

Testing for MDEV-10006

    XMLWordPrintable

Details

    • Technical task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Done
    • N/A
    • N/A
    • Tests
    • None

    Description

      Sergei Petrunia wrote:

      I need

      • a test of 10.1 vs 10.1 with the above patch
      • we need a grammar with nested LEFT/INNER joins, with various ON expressions
      • ON expression must be simple predicates over null-able as well as NOT NULL columns
      • The primary risk (thing to check for) is different query results. I don't expect crashes.

      Patch is in the comment to MDEV-10006 of 2016-05-05 15:46

      Attachments

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            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.