greptimedb/tests/cases/standalone/limit/limit.result

SELECT * FROM (SELECT SUM(number) FROM numbers LIMIT 100000000000) LIMIT 0;

+---------------------+
| sum(numbers.number) |
+---------------------+
+---------------------+

EXPLAIN SELECT * FROM (SELECT SUM(number) FROM numbers LIMIT 100000000000) LIMIT 0;

+---------------+-------------------------------------------------------------------------------+
| plan_type     | plan                                                                          |
+---------------+-------------------------------------------------------------------------------+
| logical_plan  | MergeScan [is_placeholder=false, remote_input=[                               |
|               | Limit: skip=0, fetch=0                                                        |
|               |   Projection: sum(numbers.number)                                             |
|               |     Limit: skip=0, fetch=100000000000                                         |
|               |       Projection: sum(numbers.number)                                         |
|               |         Aggregate: groupBy=[[]], aggr=[[sum(CAST(numbers.number AS UInt64))]] |
|               |           TableScan: numbers                                                  |
|               | ]]                                                                            |
| physical_plan | EmptyExec                                                                     |
|               |                                                                               |
+---------------+-------------------------------------------------------------------------------+

EXPLAIN SELECT * FROM (SELECT SUM(number) FROM numbers LIMIT 100000000000) WHERE 1=0;

+---------------+-----------------------+
| plan_type     | plan                  |
+---------------+-----------------------+
| logical_plan  | EmptyRelation: rows=0 |
| physical_plan | EmptyExec             |
|               |                       |
+---------------+-----------------------+

CREATE TABLE test (a TIMESTAMP TIME INDEX, b INTEGER);

Affected Rows: 0

INSERT INTO test VALUES (11, 23), (12, 21), (13, 22);

Affected Rows: 3

SELECT a FROM test LIMIT 1;

+-------------------------+
| a                       |
+-------------------------+
| 1970-01-01T00:00:00.011 |
+-------------------------+

SELECT b FROM test ORDER BY b LIMIT 2 OFFSET 0;

+----+
| b  |
+----+
| 21 |
| 22 |
+----+

DROP TABLE test;

Affected Rows: 0