mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-07-05 21:40: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>
19 lines
376 B
SQL
19 lines
376 B
SQL
CREATE TABLE t_last_row_append_mode(
|
|
host STRING,
|
|
ts TIMESTAMP TIME INDEX,
|
|
cpu DOUBLE,
|
|
PRIMARY KEY(host)
|
|
)
|
|
ENGINE=mito
|
|
WITH('merge_mode'='last_row');
|
|
|
|
INSERT INTO t_last_row_append_mode VALUES
|
|
('host1', 0, 1.0),
|
|
('host2', 1, 2.0);
|
|
|
|
INSERT INTO t_last_row_append_mode VALUES
|
|
('host1', 0, 10.0),
|
|
('host2', 1, 20.0);
|
|
|
|
ADMIN FLUSH_TABLE('t_last_row_append_mode');
|