mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-05-24 17:00:37 +00:00
ff4c153d4b
* test: adds sqlness test for TTL * chore: restart cluster * fix: typo * test: adds database TTL with metric engine tables
109 lines
1.8 KiB
Plaintext
109 lines
1.8 KiB
Plaintext
CREATE TABLE test_ttl(ts TIMESTAMP TIME INDEX, val INT, PRIMARY KEY(val)) WITH (ttl = '1 day');
|
|
|
|
Affected Rows: 0
|
|
|
|
INSERT INTO test_ttl VALUES
|
|
(now(), 1),
|
|
(now(), 2),
|
|
(now(), 3);
|
|
|
|
Affected Rows: 3
|
|
|
|
SELECT val from test_ttl;
|
|
|
|
+-----+
|
|
| val |
|
|
+-----+
|
|
| 1 |
|
|
| 2 |
|
|
| 3 |
|
|
+-----+
|
|
|
|
-- SQLNESS SLEEP 2s
|
|
ADMIN flush_table('test_ttl');
|
|
|
|
+-------------------------------+
|
|
| ADMIN flush_table('test_ttl') |
|
|
+-------------------------------+
|
|
| 0 |
|
|
+-------------------------------+
|
|
|
|
ADMIN compact_table('test_ttl');
|
|
|
|
+---------------------------------+
|
|
| ADMIN compact_table('test_ttl') |
|
|
+---------------------------------+
|
|
| 0 |
|
|
+---------------------------------+
|
|
|
|
SELECT val from test_ttl;
|
|
|
|
+-----+
|
|
| val |
|
|
+-----+
|
|
| 1 |
|
|
| 2 |
|
|
| 3 |
|
|
+-----+
|
|
|
|
ALTER TABLE test_ttl SET ttl = '1 second';
|
|
|
|
Affected Rows: 0
|
|
|
|
-- SQLNESS SLEEP 2s
|
|
ADMIN compact_table('test_ttl');
|
|
|
|
+---------------------------------+
|
|
| ADMIN compact_table('test_ttl') |
|
|
+---------------------------------+
|
|
| 0 |
|
|
+---------------------------------+
|
|
|
|
SELECT val from test_ttl;
|
|
|
|
++
|
|
++
|
|
|
|
ALTER TABLE test_ttl SET ttl = '1 minute';
|
|
|
|
Affected Rows: 0
|
|
|
|
INSERT INTO test_ttl VALUES
|
|
(now(), 1),
|
|
(now(), 2),
|
|
(now(), 3);
|
|
|
|
Affected Rows: 3
|
|
|
|
-- SQLNESS SLEEP 2s
|
|
ADMIN flush_table('test_ttl');
|
|
|
|
+-------------------------------+
|
|
| ADMIN flush_table('test_ttl') |
|
|
+-------------------------------+
|
|
| 0 |
|
|
+-------------------------------+
|
|
|
|
ADMIN compact_table('test_ttl');
|
|
|
|
+---------------------------------+
|
|
| ADMIN compact_table('test_ttl') |
|
|
+---------------------------------+
|
|
| 0 |
|
|
+---------------------------------+
|
|
|
|
SELECT val from test_ttl;
|
|
|
|
+-----+
|
|
| val |
|
|
+-----+
|
|
| 1 |
|
|
| 2 |
|
|
| 3 |
|
|
+-----+
|
|
|
|
DROP TABLE test_ttl;
|
|
|
|
Affected Rows: 0
|
|
|