oceanbase / oceanbase/seekdb

mysqltest merge_join.mj_slave_mapping: EXPLAIN does not generate baseline MERGE JOIN parallel plan, actual execution plan uses NESTED-LOOP JOIN / TABLE GET path

Open
#492 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

dima type: bug
Dominant language
C++
Stars
2.9k
Forks
342
Avg merge
1d 19h
Merged PRs (30d)
52

Description

Environment

  • Platform: Android (arm64)
  • Device: Android Studio emulator (emulator-5554)
  • Binary: ./data/local/tmp/seekdb
  • Startup Command: ./data/local/tmp/seekdb --nodaemon --base-dir /data/local/tmp/seekdb_data --port 5881
  • Port: 5881

Description

In the merge_join.mj_slave_mapping mysqltest, the EXPLAIN output does not generate the parallel plan based on MERGE JOIN that is stored in the baseline. Instead, the actual execution plan follows a NESTED-LOOP JOIN / TABLE GET path.

Steps to Reproduce

  1. Access the test machine.
  2. Execute the relevant steps for the merge_join.mj_slave_mapping test case.
  3. Observe the discrepancy between the plan shown by EXPLAIN (which should reflect the baseline's MERGE JOIN parallel plan) and the actual execution plan used.

Actual Result

The actual execution path deviates from the expected baseline, utilizing NESTED-LOOP JOIN and TABLE GET operations instead of the intended MERGE JOIN parallel plan.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by running the mysqltest case merge_join.mj_slave_mapping in the provided seekdb Android environment and compare its EXPLAIN output with the stored baseline. Trace the discrepancy between the expected parallel MERGE JOIN plan and the observed NESTED-LOOP JOIN / TABLE GET path; done means the test's EXPLAIN and actual execution plan match the intended baseline.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, sql
Domain
databases, testing-qa
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Needs clarification
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.