Bug Report
1. Minimal reproduce step (Required)
- preparing data
tiup bench tpch -H 0.0.0.0 -P 4000 -U root -D tpch prepare
- 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)