mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-17 02:32:56 +00:00
24e5c9f6da
* test: migrate duckdb tests Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * fix: style Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * test: add more duckdb tests Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * fix: stable order Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * chore: simplfy comments Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * chore: remove tests/cases/standalone/common/DUCKDB_MIGRATION_GUIDE.md * fix: incorrect_sql.sql Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * fix: integer flow test Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * fix: integer flow test Signed-off-by: Dennis Zhuang <killme2008@gmail.com> * docs: add todo Signed-off-by: Dennis Zhuang <killme2008@gmail.com> --------- Signed-off-by: Dennis Zhuang <killme2008@gmail.com>
72 lines
1.9 KiB
Plaintext
72 lines
1.9 KiB
Plaintext
-- Migrated from DuckDB test: test/sql/limit/test_preserve_insertion_order.test
|
|
CREATE TABLE integers(i INTEGER, ts TIMESTAMP TIME INDEX);
|
|
|
|
Affected Rows: 0
|
|
|
|
INSERT INTO integers VALUES
|
|
(1, 1000), (1, 2000), (1, 3000), (1, 4000), (1, 5000),
|
|
(2, 6000), (3, 7000), (4, 8000), (5, 9000), (10, 10000);
|
|
|
|
Affected Rows: 10
|
|
|
|
SELECT MIN(i), MAX(i), COUNT(*) FROM integers;
|
|
|
|
+-----------------+-----------------+----------+
|
|
| min(integers.i) | max(integers.i) | count(*) |
|
|
+-----------------+-----------------+----------+
|
|
| 1 | 10 | 10 |
|
|
+-----------------+-----------------+----------+
|
|
|
|
SELECT * FROM integers ORDER BY ts LIMIT 5;
|
|
|
|
+---+---------------------+
|
|
| i | ts |
|
|
+---+---------------------+
|
|
| 1 | 1970-01-01T00:00:01 |
|
|
| 1 | 1970-01-01T00:00:02 |
|
|
| 1 | 1970-01-01T00:00:03 |
|
|
| 1 | 1970-01-01T00:00:04 |
|
|
| 1 | 1970-01-01T00:00:05 |
|
|
+---+---------------------+
|
|
|
|
SELECT * FROM integers ORDER BY ts LIMIT 3 OFFSET 2;
|
|
|
|
+---+---------------------+
|
|
| i | ts |
|
|
+---+---------------------+
|
|
| 1 | 1970-01-01T00:00:03 |
|
|
| 1 | 1970-01-01T00:00:04 |
|
|
| 1 | 1970-01-01T00:00:05 |
|
|
+---+---------------------+
|
|
|
|
SELECT * FROM integers WHERE i IN (1, 3, 5, 10) ORDER BY i;
|
|
|
|
+----+---------------------+
|
|
| i | ts |
|
|
+----+---------------------+
|
|
| 1 | 1970-01-01T00:00:01 |
|
|
| 1 | 1970-01-01T00:00:02 |
|
|
| 1 | 1970-01-01T00:00:03 |
|
|
| 1 | 1970-01-01T00:00:04 |
|
|
| 1 | 1970-01-01T00:00:05 |
|
|
| 3 | 1970-01-01T00:00:07 |
|
|
| 5 | 1970-01-01T00:00:09 |
|
|
| 10 | 1970-01-01T00:00:10 |
|
|
+----+---------------------+
|
|
|
|
SELECT * FROM integers WHERE i IN (1, 3, 5, 10) ORDER BY i, ts LIMIT 3;
|
|
|
|
+---+---------------------+
|
|
| i | ts |
|
|
+---+---------------------+
|
|
| 1 | 1970-01-01T00:00:01 |
|
|
| 1 | 1970-01-01T00:00:02 |
|
|
| 1 | 1970-01-01T00:00:03 |
|
|
+---+---------------------+
|
|
|
|
-- Clean up
|
|
DROP TABLE integers;
|
|
|
|
Affected Rows: 0
|
|
|