Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Missing sub plan info of ShuffleReceiver executor #27989

Closed
mmyj opened this issue Sep 13, 2021 · 3 comments · Fixed by #27992
Closed

Missing sub plan info of ShuffleReceiver executor #27989

mmyj opened this issue Sep 13, 2021 · 3 comments · Fixed by #27992
Assignees
Labels
affects-5.2 This bug affects 5.2.x versions. severity/major sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@mmyj
Copy link
Member

mmyj commented Sep 13, 2021

Bug Report

1. Minimal reproduce step (Required)

  1. preparing data
tiup bench tpch -H 0.0.0.0 -P 4000 -U root -D tpch prepare
  1. executing query
use tpch;
explain analyze
SELECT MIN(ps_supplycost) over (partition by p_partkey) as min_ps_supplycost
FROM tpch.part,
     tpch.partsupp,
     tpch.supplier,
     tpch.nation,
     tpch.region
WHERE p_partkey = ps_partkey
  AND s_nationkey = n_nationkey
  AND s_suppkey = ps_suppkey
  AND n_regionkey = r_regionkey;

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

Projection_21
└─Shuffle_64
  └─Window_22
    └─Sort_63
      └─ShuffleReceiver_69
          └─sub join plan

3. What did you see instead (Required)

Projection_21
└─Shuffle_64
  └─Window_22
    └─Sort_63
      └─ShuffleReceiver_69

4. What is your TiDB version? (Required)

  • master
  • 5.2.1
@mmyj mmyj added the type/bug The issue is confirmed as a bug. label Sep 13, 2021
@mmyj
Copy link
Member Author

mmyj commented Sep 13, 2021

The explainPlanInRowFormat function miss a processing to format PhysicalShuffleReceiverStub sub plan.

@chrysan
Copy link
Contributor

chrysan commented Nov 22, 2021

/assign

@github-actions
Copy link

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.

@jebter jebter added the affects-5.2 This bug affects 5.2.x versions. label Jan 18, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-5.2 This bug affects 5.2.x versions. severity/major sig/planner SIG: Planner type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants