mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-07-03 20:40:37 +00:00
6b587eb0a5
* test: add recent sqlness compat cases Signed-off-by: discord9 <discord9@163.com> * test: add more sqlness compat cases Signed-off-by: discord9 <discord9@163.com> --------- Signed-off-by: discord9 <discord9@163.com>
13 lines
269 B
SQL
13 lines
269 B
SQL
CREATE TABLE t_table_ttl(
|
|
ts TIMESTAMP TIME INDEX,
|
|
host STRING PRIMARY KEY,
|
|
val INT
|
|
)
|
|
WITH('ttl'='7d');
|
|
|
|
INSERT INTO t_table_ttl VALUES
|
|
('2099-02-08 00:00:00+0000', 'host_a', 1),
|
|
('2099-02-08 00:01:00+0000', 'host_b', 2);
|
|
|
|
ADMIN FLUSH_TABLE('t_table_ttl');
|