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

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

Affected Rows: 0

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

Affected Rows: 3

SELECT a FROM test LIMIT 1;

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

SELECT a FROM test LIMIT 1.25;

Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: Unexpected expression in LIMIT clause

SELECT a FROM test LIMIT 2-1;

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

SELECT a FROM test LIMIT a;

Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: Unexpected expression in LIMIT clause

SELECT a FROM test LIMIT a+1;

Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: Unexpected expression in LIMIT clause

SELECT a FROM test LIMIT SUM(42);

Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: Unexpected expression in LIMIT clause

SELECT a FROM test LIMIT row_number() OVER ();

Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: Unexpected expression in LIMIT clause

CREATE TABLE test2 (a STRING, ts TIMESTAMP TIME INDEX);

Affected Rows: 0

INSERT INTO test2 VALUES ('Hello World', 1);

Affected Rows: 1

SELECT * FROM test2 LIMIT 3;

+-------------+-------------------------+
| a           | ts                      |
+-------------+-------------------------+
| Hello World | 1970-01-01T00:00:00.001 |
+-------------+-------------------------+

select 1 limit date '1992-01-01';

Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: Unexpected expression in LIMIT clause

CREATE TABLE integers(i TIMESTAMP TIME INDEX);

Affected Rows: 0

INSERT INTO integers VALUES (1), (2), (3), (4), (5);

Affected Rows: 5

SELECT * FROM integers LIMIT 3;

+-------------------------+
| i                       |
+-------------------------+
| 1970-01-01T00:00:00.001 |
| 1970-01-01T00:00:00.002 |
| 1970-01-01T00:00:00.003 |
+-------------------------+

SELECT * FROM integers LIMIT 4;

+-------------------------+
| i                       |
+-------------------------+
| 1970-01-01T00:00:00.001 |
| 1970-01-01T00:00:00.002 |
| 1970-01-01T00:00:00.003 |
| 1970-01-01T00:00:00.004 |
+-------------------------+

SELECT * FROM integers as int LIMIT (SELECT MIN(integers.i) FROM integers);

Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: Unexpected expression in LIMIT clause

SELECT * FROM integers as int OFFSET (SELECT MIN(integers.i) FROM integers);

Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: Unexpected expression in OFFSET clause

SELECT * FROM integers as int LIMIT (SELECT MAX(integers.i) FROM integers) OFFSET (SELECT MIN(integers.i) FROM integers);

Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: Unexpected expression in OFFSET clause

SELECT * FROM integers as int LIMIT (SELECT max(integers.i) FROM integers where i > 5);

Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: Unexpected expression in LIMIT clause

SELECT * FROM integers as int LIMIT (SELECT max(integers.i) FROM integers where i > 5);

Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: Unexpected expression in LIMIT clause

SELECT * FROM integers as int LIMIT (SELECT NULL);

Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: Unexpected expression in LIMIT clause

SELECT * FROM integers as int LIMIT (SELECT -1);

Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: Unexpected expression in LIMIT clause

SELECT * FROM integers as int LIMIT (SELECT 'ab');

Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: Unexpected expression in LIMIT clause

DROP TABLE integers;

Affected Rows: 0

DROP TABLE test;

Affected Rows: 0

DROP TABLE test2;

Affected Rows: 0