pingcap / pingcap/tidb

planner: explain explore outputs nothing

Open
#64,453 0 comments 1 reaction 0 assignees View on GitHub
component/spm sig/planner type/bug
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

```
mysql> plan replayer load /Users/zhangyuanjia/Downloads/replayer1106.zip

mysql> source /Users/zhangyuanjia/Downloads/replayer1106/sql/explain_explaore.sql;
Empty set (2.509 sec)
```

Contact me to get the plan replayer file internally.

`Explain Explore` output nothing, which is unexpected.

The reason is that we'll construct a set of hint from all explored plans to reproduce them, but due to some limitation of the process of constructing these hints (implemented in `GenHintsFromFlatPlan`), these hints might not be able to reproduce its corresponding plan. Then in this case we just filter out this plan.
Since the query in this plan-replayer is relatively complex, we all its possible plans are not be able to reproduce via our constructed hints, then then output is empty.
We need to enhance `GenHintsFromFlatPlan` or figure out another way to reproduce the plan.

Image

### 2. What did you expect to see? (Required)

Some plans

### 3. What did you see instead (Required)

Empty

### 4. What is your TiDB version? (Required)

Master

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.