mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-07-04 13:00:38 +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>
20 lines
387 B
SQL
20 lines
387 B
SQL
CREATE TABLE t_last_row_merge(
|
|
host STRING,
|
|
ts TIMESTAMP TIME INDEX,
|
|
cpu DOUBLE,
|
|
memory DOUBLE,
|
|
PRIMARY KEY(host)
|
|
)
|
|
ENGINE=mito
|
|
WITH('merge_mode'='last_row');
|
|
|
|
INSERT INTO t_last_row_merge VALUES
|
|
('host1', 0, 0, NULL),
|
|
('host2', 1, NULL, 1);
|
|
|
|
INSERT INTO t_last_row_merge VALUES
|
|
('host1', 0, NULL, 10),
|
|
('host2', 1, 11, NULL);
|
|
|
|
ADMIN FLUSH_TABLE('t_last_row_merge');
|