mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-07 22:02:56 +00:00
d7b6718be0
* define server mode Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * bump sqlness Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * all good Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * clean up Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * refactor: Move config generation logic from Env to ServerMode Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * finalize Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * change license header Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * rename variables Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * override parallelism Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * rename more variables Signed-off-by: Ruihang Xia <waynestxia@gmail.com> --------- Signed-off-by: Ruihang Xia <waynestxia@gmail.com>
85 lines
1.6 KiB
SQL
85 lines
1.6 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';
|
|
|
|
DROP DATABASE test_ttl_db_2;
|