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

FULL JOIN result difference2

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Duplicate
    • None
    • N/A
    • Optimizer
    • None
    • Unexpected results
    • Q3/2026 Server Maintenance

    Description

      Result Mismatch (2) vs (2) :

      MariaDB rows (2):

      NULL	26	NULL	NULL	NULL
      		 
      NULL	26	NULL	NULL	NULL

      Postgres rows (2):

      5	26	0	5	xx
      		 
      8	26	0	13	aa

      How to repro:

      --------------------------
      mariadb-setup.txt
      mariadb-query5.txt

      postgres-setup.txt
      postgres-query5.txt

      Attachments

        1. mariadb-query5.txt
          1 kB
        2. mariadb-setup.txt
          134 kB
        3. postgres-query5.txt
          1 kB
        4. postgres-setup.txt
          134 kB

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-39014 FULL JOIN Algorithm, Phase 2

          • Critical - Crashes, loss of data, severe memory leak.
          • In Review

          Activity

            People

              Gosselin Dave Gosselin
              mariadb-pavithrapandith Pavithra Pandith
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 0d
                  0d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.5d
                  0.5d

                  Git Integration

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