mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-05-16 13:00:40 +00:00
8b944268da
* feat: ttl zero filter * refactor: use TimeToLive enum * fix: unit test * tests: sqlness * refactor: Option<TTL> None means UNSET * tests: sqlness * fix: 10000 years --> forever * chore: minor refactor from reviews * chore: rename back TimeToLive * refactor: split imme request from normal requests * fix: use correct lifetime * refactor: rename immediate to instant * tests: flow sink table default ttl * refactor: per review * tests: sqlness * fix: ttl alter to instant * tests: sqlness * refactor: per review * chore: per review * feat: add db ttl type&forbid instant for db * tests: more unit test
83 lines
1.5 KiB
SQL
83 lines
1.5 KiB
SQL
CREATE DATABASE test_ttl_db WITH (ttl = '1 second');
|
|
|
|
USE test_ttl_db;
|
|
|
|
CREATE TABLE test_ttl(ts TIMESTAMP TIME INDEX, val INT);
|
|
|
|
SHOW CREATE TABLE test_ttl;
|
|
|
|
SHOW CREATE DATABASE test_ttl_db;
|
|
|
|
ALTER DATABASE test_ttl_db SET ttl = '1 day';
|
|
|
|
SHOW CREATE TABLE test_ttl;
|
|
|
|
SHOW CREATE DATABASE test_ttl_db;
|
|
|
|
ALTER TABLE test_ttl SET 'ttl' = '6 hours';
|
|
|
|
SHOW CREATE TABLE test_ttl;
|
|
|
|
ALTER TABLE test_ttl SET 'ttl' = 'instant';
|
|
|
|
SHOW CREATE TABLE test_ttl;
|
|
|
|
ALTER TABLE test_ttl SET 'ttl' = '0s';
|
|
|
|
SHOW CREATE TABLE test_ttl;
|
|
|
|
ALTER TABLE test_ttl SET 'ttl' = 'forever';
|
|
|
|
SHOW CREATE TABLE test_ttl;
|
|
|
|
SHOW CREATE DATABASE test_ttl_db;
|
|
|
|
ALTER TABLE test_ttl UNSET 'ttl';
|
|
|
|
SHOW CREATE TABLE test_ttl;
|
|
|
|
SHOW CREATE DATABASE test_ttl_db;
|
|
|
|
ALTER DATABASE test_ttl_db SET 'ttl' = 'forever';
|
|
|
|
SHOW CREATE TABLE test_ttl;
|
|
|
|
SHOW CREATE DATABASE test_ttl_db;
|
|
|
|
ALTER DATABASE test_ttl_db SET 'ttl' = '0s';
|
|
|
|
SHOW CREATE TABLE test_ttl;
|
|
|
|
SHOW CREATE DATABASE test_ttl_db;
|
|
|
|
ALTER DATABASE test_ttl_db SET 'ttl' = 'instant';
|
|
|
|
SHOW CREATE TABLE test_ttl;
|
|
|
|
SHOW CREATE DATABASE test_ttl_db;
|
|
|
|
ALTER DATABASE test_ttl_db UNSET 'ttl';
|
|
|
|
SHOW CREATE TABLE test_ttl;
|
|
|
|
SHOW CREATE DATABASE test_ttl_db;
|
|
|
|
ALTER TABLE test_ttl UNSET 'ttl';
|
|
|
|
SHOW CREATE TABLE test_ttl;
|
|
|
|
SHOW CREATE DATABASE test_ttl_db;
|
|
|
|
DROP TABLE test_ttl;
|
|
|
|
USE public;
|
|
|
|
DROP DATABASE test_ttl_db;
|
|
|
|
-- test both set database to instant and alter ttl to instant for a database is forbidden
|
|
CREATE DATABASE test_ttl_db WITH (ttl = 'instant');
|
|
|
|
CREATE DATABASE test_ttl_db_2 WITH (ttl = '1s');
|
|
|
|
ALTER DATABASE test_ttl_db_2 SET 'ttl' = 'instant';
|