mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-03 11:52:54 +00:00
10ecc30817
* check partition for aggr plan Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * handle empty partition rule Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * remove CheckPartition option Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * add test Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * update some valid sqlness result Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * opt-out promql plan and update sqlness Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix limit Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix insert select subquery Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * update unit test result Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix typo Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * Update src/query/src/dist_plan/analyzer.rs Co-authored-by: Yingwen <realevenyag@gmail.com> --------- Signed-off-by: Ruihang Xia <waynestxia@gmail.com> Co-authored-by: Yingwen <realevenyag@gmail.com>
26 lines
1000 B
Plaintext
26 lines
1000 B
Plaintext
SELECT * FROM (SELECT SUM(number) FROM numbers LIMIT 100000000000) LIMIT 0;
|
|
|
|
++
|
|
++
|
|
|
|
EXPLAIN SELECT * FROM (SELECT SUM(number) FROM numbers LIMIT 100000000000) LIMIT 0;
|
|
|
|
+---------------+----------------------------------+
|
|
| plan_type | plan |
|
|
+---------------+----------------------------------+
|
|
| logical_plan | MergeScan [is_placeholder=false] |
|
|
| physical_plan | EmptyExec: produce_one_row=false |
|
|
| | |
|
|
+---------------+----------------------------------+
|
|
|
|
EXPLAIN SELECT * FROM (SELECT SUM(number) FROM numbers LIMIT 100000000000) WHERE 1=0;
|
|
|
|
+---------------+----------------------------------+
|
|
| plan_type | plan |
|
|
+---------------+----------------------------------+
|
|
| logical_plan | MergeScan [is_placeholder=false] |
|
|
| physical_plan | EmptyExec: produce_one_row=false |
|
|
| | |
|
|
+---------------+----------------------------------+
|
|
|