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
Nobody has claimed this yet.
- 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
- Access the test machine.
- Execute the relevant steps for the
merge_join.mj_slave_mappingtest case. - 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
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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