mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2025-12-27 16:32:54 +00:00
5d8b0e8154
* fix all hard error Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix nextest Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * trivial changes Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix order by Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix sql keyword and data type Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix range exec's input partitioning Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix cover input type Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix explain analyze Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * update distributed mode sqlness result Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix lints Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * update locks Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * downgrade dlv-list Signed-off-by: Ruihang Xia <waynestxia@gmail.com> --------- Signed-off-by: Ruihang Xia <waynestxia@gmail.com>
207 lines
5.5 KiB
Plaintext
207 lines
5.5 KiB
Plaintext
create table t_1 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_2 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_3 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_4 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_5 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_6 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_7 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_8 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_9 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
create table t_10 (ts timestamp time index, vin string, val int);
|
|
|
|
Affected Rows: 0
|
|
|
|
-- SQLNESS REPLACE (-+) -
|
|
-- SQLNESS REPLACE (\s\s+) _
|
|
-- SQLNESS REPLACE (RoundRobinBatch.*) REDACTED
|
|
-- SQLNESS REPLACE (Hash.*) REDACTED
|
|
-- SQLNESS REPLACE (peers.*) REDACTED
|
|
explain
|
|
select *
|
|
from
|
|
t_1
|
|
INNER JOIN t_2 ON t_2.ts = t_1.ts
|
|
AND t_2.vin = t_1.vin
|
|
INNER JOIN t_3 ON t_3.ts = t_2.ts
|
|
AND t_3.vin = t_2.vin
|
|
INNER JOIN t_4 ON t_4.ts = t_3.ts
|
|
AND t_4.vin = t_3.vin
|
|
INNER JOIN t_5 ON t_5.ts = t_4.ts
|
|
AND t_5.vin = t_4.vin
|
|
INNER JOIN t_6 ON t_6.ts = t_5.ts
|
|
AND t_6.vin = t_5.vin
|
|
INNER JOIN t_7 ON t_7.ts = t_6.ts
|
|
AND t_7.vin = t_6.vin
|
|
INNER JOIN t_8 ON t_8.ts = t_7.ts
|
|
AND t_8.vin = t_7.vin
|
|
INNER JOIN t_9 ON t_9.ts = t_8.ts
|
|
AND t_9.vin = t_8.vin
|
|
INNER JOIN t_10 ON t_10.ts = t_9.ts
|
|
AND t_10.vin = t_9.vin
|
|
where
|
|
t_1.vin is not null
|
|
order by t_1.ts desc
|
|
limit 1;
|
|
|
|
+-+-+
|
|
| plan_type_| plan_|
|
|
+-+-+
|
|
| logical_plan_| Limit: skip=0, fetch=1_|
|
|
|_|_Sort: t_1.ts DESC NULLS FIRST, fetch=1_|
|
|
|_|_Inner Join: t_9.ts = t_10.ts, t_9.vin = t_10.vin_|
|
|
|_|_Inner Join: t_8.ts = t_9.ts, t_8.vin = t_9.vin_|
|
|
|_|_Inner Join: t_7.ts = t_8.ts, t_7.vin = t_8.vin_|
|
|
|_|_Inner Join: t_6.ts = t_7.ts, t_6.vin = t_7.vin_|
|
|
|_|_Inner Join: t_5.ts = t_6.ts, t_5.vin = t_6.vin_|
|
|
|_|_Inner Join: t_4.ts = t_5.ts, t_4.vin = t_5.vin_|
|
|
|_|_Inner Join: t_3.ts = t_4.ts, t_3.vin = t_4.vin_|
|
|
|_|_Inner Join: t_2.ts = t_3.ts, t_2.vin = t_3.vin_|
|
|
|_|_Inner Join: t_1.ts = t_2.ts, t_1.vin = t_2.vin_|
|
|
|_|_Filter: t_1.vin IS NOT NULL_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_Filter: t_2.vin IS NOT NULL_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
|_|_MergeScan [is_placeholder=false]_|
|
|
| physical_plan | GlobalLimitExec: skip=0, fetch=1_|
|
|
|_|_SortPreservingMergeExec: [ts@0 DESC], fetch=1_|
|
|
|_|_SortExec: TopK(fetch=1), expr=[ts@0 DESC]_|
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_FilterExec: vin@1 IS NOT NULL_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_FilterExec: vin@1 IS NOT NULL_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_CoalesceBatchesExec: target_batch_size=8192_|
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_RepartitionExec: partitioning=REDACTED
|
|
|_|_MergeScanExec: REDACTED
|
|
|_|_|
|
|
+-+-+
|
|
|
|
drop table t_1;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_2;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_3;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_4;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_5;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_6;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_7;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_8;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_9;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table t_10;
|
|
|
|
Affected Rows: 0
|
|
|