Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-38692

COALESCE() Columns for NATURAL FULL JOIN

    XMLWordPrintable

Details

    • Task
    • Status: In Review (View Workflow)
    • Major
    • Resolution: Unresolved
    • 13.1
    • None

    Description

      FULL JOIN yields result sets with columns from both tables participating in the join (for the sake of explanation, assume base tables).

      However, NATURAL FULL JOIN should not show what amount to duplicate columns in the output. Rather, it should COALESCE() the output columns so that only one set of columns from the FULL JOIN appear in the output.

      Attachments

        Activity

          People

            monty Michael Widenius
            Gosselin Dave Gosselin
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.