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
298 B
SQL
13 lines
298 B
SQL
SELECT ts, host, val FROM t_table_ttl ORDER BY ts, host;
|
|
|
|
SHOW CREATE TABLE t_table_ttl;
|
|
|
|
ALTER TABLE t_table_ttl SET 'ttl' = '30d';
|
|
|
|
SHOW CREATE TABLE t_table_ttl;
|
|
|
|
INSERT INTO t_table_ttl VALUES
|
|
('2099-02-08 00:02:00+0000', 'host_c', 3);
|
|
|
|
SELECT ts, host, val FROM t_table_ttl ORDER BY ts, host;
|