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

FULL JOIN Algorithm, Phase 2

    XMLWordPrintable

Details

    Description

      This ticket corresponds to "phase 2" in the epic: "Phase 2: Allow one side to have multiple tables (it will be put first into the join order)", building off of phase 1 work in MDEV-38693.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39619 Assertion `found_tables > 0' failed

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39663 Assertion `found_tables > 0' failed

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39713 Assertion `found_tables > 0' failed

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39715 Assertion `next_emb->nested_join->counter <= next_emb->nested_join->n_tables' failed

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39746 Segmentation fault with FULL JOIN

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39766 Assertion `m_psi_batch_mode == PSI_BATCH_MODE_NONE' failed

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39936 FULL JOIN result difference1

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39967 FULL JOIN result difference2

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

          Task - A task that needs to be done. MDEV-40007 Unnecessary NATURAL FULL JOIN COALESCE

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40045 FULL JOIN result difference3

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40069 FULL JOIN result difference 4

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39560 Assertion `found_tables > 0' failed

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39567 Segmentation fault with FULL JOIN

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39569 Assertion `found_tables > 0' failed at sql_select.cc

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39605 Assertion `!tbl->nested_join || tbl->sj_on_expr' failed

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39607 Segmentation fault while testing FULL OUTER JOIN

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39618 Assertion `table->no_keyread || !table->covering_keys.is_set(tab->index) || table->file->keyread == tab->index' failed

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-39659 FULL JOIN algorithm for single table(?) and join buffer (BNL[-H])

          • Major - Major loss of function.
          • Open

          Activity

            People

              psergei Sergei Petrunia
              Gosselin Dave Gosselin
              Dave Gosselin Dave Gosselin
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 20d Original Estimate - 20d
                  20d
                  Remaining:
                  Time Spent - 37d 1h 4m Remaining Estimate - 1.5d
                  1.5d
                  Logged:
                  Time Spent - 37d 1h 4m Remaining Estimate - 1.5d
                  37d 1h 4m

                  Git Integration

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